Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Drillthrough- Filtering Bottom Up

Hello,

 

We have created a flow in which the user drills through from a column chart to various details pages. The column chart represents a count (based on unique rules based on the client's business). The requirement is to be able to 'filter' out certain entries based off of attribues such as: year, identification number, VIN number etc. Similar to the functionality of a slicer based on date for instance, when the slicer is moved (on any page- synced slicers), the count adjusts accordingly.

 

I am wanting what I filter or exclude on the details page to affect the count on the parent drill through page, basically filtering upwards. Please let me know if there are any ideas besides filter across pages based off of an identity key. (this is a very last resort option as it is very clunky, and the user would be faced with having to individually filter out 1,000+ cases)

 

Example:

52 counts on parent/graph page

I exclude/filter out 20 'cases'

Graph should change to 32 counts

 

Please let me know your thoughts!

Thank you very much!