CA 11.1.7
I have a Stacked Bar chart defined as follows:
- Bars - Practices
- Colors - Service Types
- Length - Amount
The list contains far too many practices to be useful, so I want to reduce to a Top 10/20 etc.
What I want to get is the Top X Practices by Total Amount broken down by Service Type.
However, when I put a Top Count on Amount, I think I get the Top 10 Types and their associated practices - I haven't verified this.
Am I missing something simple?
In my opinion, I don't think I should have to create a rank in the Data Module to enable this functionality.
Thanks in advance,
Adam.
This really was a "moment" on my end - What I missed was imputing the "By" Field when setting the Top X filter on the Bars field.
This makes total sense and was something I fundamentally knew, but was just missing.
Thanks,
Adam