If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

RESOLVED: Top X for Stacked Bar/Column Chart

Started by adam_mc, 03 Nov 2023 12:51:53 PM

Previous topic - Next topic

adam_mc

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.

adam_mc

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