Forum Discussion
change filter options when using drill down
I would like to be able to change or remove visual filter options as I move down a hierarchy using drill down. I have a combined line and clustered column chart that has accounts and account areas (hierarchy) sharing the x axis and shows cars parked today, average cars parked this day of the week, and the line is a comparison percentage for parked today over average. For the top level, accounts, I only want to show those accounts where the percentage is below 80% or over 120%, but when I drill down to areas within an account I no longer want that filter active. I'm sure this must be possible, but I haven't seen or figured out how to do it. Help please.
- Craig
2 Replies
Hi CraigSchulz,
I'm not very clear about your scenario.
If it is convenient, could you share some screenshots which could reproduce your scenario and your desired output so that we could help further on it?
Best Regards,
Cherry
Here is part of a visual showing account 130, average parked at noon, this day of the week, parked at noon today, and comparison percentage today/average.Notice cars parked are 178 and 207; comparison percentage is 116%. Drilling down to parking areas within the account shows the following:
Now, my client only wants to view, at the account level, only those accounts that are either below 80% or over 120% of average. When I apply that filter at the account level I get the following:
I want account 130 not to show now as the comparison percent was 116%, but it does appear with different totals for cars parked and a comparison percentage of 122%. This is because the "less than 80% and greater than 120%" filter got applied to the area level as well as the account level, so some of the areas don't appear now because of the comparison %, the totals drop to numbers that don't represent the entire account.
In other words, I want the filter to apply at the account level, but when I drill down to the account area level, I want all areas to appear regardless of the comparison percentage. How can I make this happen?
- Craig
