Multiple filters in table (vs charts) like reports

  • 1
  • Problem
  • Updated 1 year ago
  • In Progress
Hi everyone, it looks like after the last major release (Sep, 5) table reporting lost its one of the most important (at least for us) functionality - ability to apply several filter upon one table. For instance, we always used heavily sorting our accounts simultaneously (1) by health color (RYG) and (2) by MRR within the health buckets. I don't see this possibility anymore. Am I missing out any settings?
Photo of Lyubov Penyugalova

Lyubov Penyugalova

  • 430 Points 250 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,802 Points 20k badge 2x thumb
Hi Lyubov,

You should be able to add any additional filters by clicking on the filter icon and then adding the fields that you wish to filter on. See example below

(for some reason the image file won't upload, but here is the link: https://dr5mo5s7lqrtc.cloudfront.net/items/0f0M1V0n0y3Z0S3V3d3t/Screen%20recording%202017-09-13%20at...)
(Edited)
Photo of Lyubov Penyugalova

Lyubov Penyugalova

  • 430 Points 250 badge 2x thumb
I'm very sorry I think I wasn't clear (and this is totally my fault) in explaining the problem. It's not about filters, it's about consequential sorting different columns.
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,802 Points 20k badge 2x thumb
I see. So having the ability to sort on one column and then sort on a second column where the result is this:
  • Data is arranged based on second column sort
  • If any second column data is identical then the first column sort comes into play
Is this right?

Currently reports do not support this. 

Here are a couple community threads that discuss this topic:
https://community.gainsight.com/gainsight/topics/sort-a-report-by-multiple-columns
and
https://community.gainsight.com/gainsight/topics/sort-by-two-columns-on-customer-tab
Photo of Lyubov Penyugalova

Lyubov Penyugalova

  • 430 Points 250 badge 2x thumb
yep, that's exactly what I mean. Thanks for the links, Dan! I'm pretty sure there was this possibility earlier.
(Edited)