Skip to main content
seth
Expert ⭐️
Sep 15, 2016 5:55 PM UTC

Filtering in Reports for "does not start with"

I'm trying to create a report on our Google Analytics data that excludes the 'system users', where our product is accessing the product on our customer's behalf to do nightly automated tasks. I like having those pageviews in the data, but I don't want them in this particular report.

Those users are identifiable because their username begins with "ss-". I can filter a report for "contains", "does not contain", or "starts with", but I can't filter it for "does not start with".

I tried to add the "starts with" filter and then change the advanced filtering logic ("A AND B") to "A NOT B", but I got an error that that expression was invalid. So perhaps this feature request is really to support "NOT" logic in those advanced filtering logic, which of course could also be useful in Rules, Power Lists, etc.

    6 replies

    darkknight
    Expert ⭐️
    Sep 15, 2016 6:01 PM UTC
    Love this idea and wish I had thought of it. 🙂
    Translate
    Jeff Kirkpatrick
    seth
    sethAuthor
    Expert ⭐️
    Sep 15, 2016 6:10 PM UTC

    Translate
    AI Transformation @ Gainsight
    sudarshan_vig
    Contributor ⭐️⭐️⭐️⭐️⭐️
    Sep 16, 2016 10:08 AM UTC
    Hey Seth/Jeff, let me see what can be done regarding this. Initially, we are trying to get parity of operators in filters between SFDC and MDA reports. Once we do that, I will get to this. Will let you know once its picked up! Thanks a lot.
    Translate
    danella_stephany
    Contributor ⭐️⭐️⭐️
    Sep 16, 2016 12:23 PM UTC
    Would love more functionality in the filter logic, including "NOT", "OR". This is similar to another request I submitted where I want the ability to exclude "This Quarter" in reporting. https://community.gainsight.com/gainsight/topics/how-can-i-exclude-the-current-quarter-in-reporting
    Translate
    phil_kowalski
    Contributor ⭐️⭐️⭐️
    Oct 7, 2016 8:29 PM UTC
    Ran into a case today where I could have really used a "do not start with" filter option or NOT logic option.
    Translate
    andy_roy
    Helper ⭐️
    Jul 12, 2018 1:56 PM UTC
    This still feels like a worthy request, though I might want to call it something like "Allow NOT as operator in filter logic"?  
    Translate