Skip to main content
darkknight
Expert ⭐️
September 24, 2015
Released

Gainsight Dashboards: Need ability to add multiple entries in the same free-text Filter (similar to how SFDC reporting works)

Related products:CS Reports
  • September 24, 2015
  • 30 replies
  • 367 views
In Salesforce reporting, if I want to filter on a field that is not a "picklist," I am able to enter multiple options in the same Filter sequence, i.e.

"SuperRegion" is equal to "NA, EMEA, LATAM, APAC"

In Gainsight I have to enter separate filters, i.e.

"SuperRegion" is equal to "NA"
OR
"SuperRegion" is equal to "EMEA"
OR
"SuperRegion" is equal to "LATAM"
OR
"SuperRegion" is equal to "APAC"

This adds complexity to the building of reports.  The filter should have the logic to be able to identify that if I have a comma separated list to treat them as separate entries, that way if I want to filter, for example on any account that falls under the SuperRegion NA or LATAM I can just enter:

"SuperRegion" is equal to "NA, LATAM"

This would also give users the flexibility, when accessing the filter from the Dashboard, to be able to add multiple entries or a single entry in the field upon which to sort.  

    30 replies

    jordan_cook
    Contributor ⭐️⭐️⭐️⭐️⭐️
    October 31, 2018
    I'm excited for this feature. I have worked with a few different customer who have requested this. It would be excellent to have this work on dashboard global filters as well.

    ben
    Helper ⭐️⭐️⭐️
    October 31, 2018
    Whoa! Am I reading this right? "Planned"!?!? That is great news.

    -Ben
    heather_hansen
    VIP ⭐️⭐️⭐️⭐️⭐️
    November 1, 2018
    Excited for this as well! Just had to build out a report and add the same filter 6 times to accommodate multiple entries.

    zacharyhenaultsprinklrcom
    Contributor ⭐️
    November 1, 2018
    This would be great for us. Will it ever be put on the road map?

    bhavani_murali
    Contributor ⭐️⭐️⭐️
    November 2, 2018
    This item is already part of the Roadmap, targeted to be shipped in first quarter, next year!!

    rakesh
    Gainsight Employee ⭐️
    Lets put your data to work!
    April 3, 2019
    Hi Everyone,

    Excited to share that we will be shipping Includes operator in filter which will allow you to add multiple values (upto 10) to a single filter. This works in report filters, dashboard filters and in some filters across product(cockpit, rules, etc.). I've been using it when building reports internally in Gainsight and I'm loving it! Make sure you change the filter operator to includes.

    Attaching a screenshot for the same:



    darkknight
    Expert ⭐️
    April 3, 2019
    Glad to finally have this! Will this get extended to Rules Engine and Journey Orchestrator queries as well?

    Jeff Kirkpatrick
    pele
    Helper ⭐️⭐️⭐️
    April 3, 2019
    Great update! And from the looks of it, I think I like the usability more than the potentially long list of values in a Salesforce report where finding a value to delete isn’t the easiest thing to do. And to Jeff’s point, also interested to see if this will extend to Rules and JO.

    rakesh
    Gainsight Employee ⭐️
    Lets put your data to work!
    April 8, 2019
    It will automatically be extended for filters on MDA fields in Rules Engine.

    On the extension plan, @jitin_mehndiratta and @abhishek_sivaraman can add more details.

    darkknight
    Expert ⭐️
    July 26, 2019
    Bummer this only works for Gainsight MDA fields and not Salesforce.

    Jeff Kirkpatrick