Forum Discussion
change filter options when using drill down
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
- CraigSchulz8 years ago
Helper II
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