Forum Discussion
So, it seems that what we're seeing with new style reports is 'currently the correct behaviour'.
When switched to old style, the dynamic filters also do not adjust based on other dynamic filter selections, so it doesn't help us out in this case. It's been a while since I've used old style reports and I can't remember if this has always been the case; I suspect it has been.
- MarkShnier__You2 months agoQrew Legend
Yes, dynamic filters have always behaved that way. They do not dynamically refresh the dynamic filters as you make one selection. But if you have a business need for that, a used case then there are alternatives.
Yes, dynamic filters have always behaved that way. They do not dynamically refresh the dynamic filters as you make one selection. But if you have a business need for that, a used case then there are alternatives.
One alternative which I don't really like, is to start with a report that has an asked the user question to immediately narrow down the qualifying records, then your dynamic filters may be more relevant.
is to start with a report that has an asked, the user question to immediately narrow down the qualifying records, then your dynamic filters may be more relevant.
But my preferred method would be to create a summary report with rows and columns for the user to land on and then according to where they drill into the summary report, into a row or a column heading or a cell, then they will instantly be filtered to just include those qualifying records.
Then you can decide from there if you want to land the user on another summary report or write into a report of details. take note that when you can figure a summary report you can also control the drill down behavior, as to which report it drills down to the drill down too should be an unfiltered report as it will inherit the filters according to where you drilled down.