Summarizing data in a Stacked Bar Chart

[bscherzer]

I am creating a stacked bar chart that is displaying sales per product, but there are several products that show up with very little sales. I'd like to lump all products with less than $1000 in sales into one bar. Is this possible to do in Cognos Business Analytics?

[MFGF]

I am creating a stacked bar chart that is displaying sales per product, but there are several products that show up with very little sales. I'd like to lump all products with less than $1000 in sales into one bar. Is this possible to do in Cognos Business Analytics?

Hi,

Create a query calculation to bucket the products with less than 1000 sales value together, and use this instead of the Product item

eg

if (total([your Sales measure] for [your Product item]) < 1000) then ('Others') else ([your Product item])

Cheers!

MF.

[Kiran P]

Hi,

See if you can use Summarize Small Items property of the chart to summarize smaller values based on the criteria you can define in that property. See attached.

Same is available in cognos analytics.

Thanks
Kiran

[bscherzer]

Thanks for the replies. I'm going to try MFGF's query calculation and that should work. We're using Cognos Analytics v11 so I don't think I have the Summarize Small Items property on the chart. The GUI in your screenshot looks a lot different than the tools that we have to work with. Thanks everyone!

[bscherzer]

Thanks again everyone! I was able to use the query calculation in Framework Manager and that worked well.

[Kiran P]

Thanks again everyone! I was able to use the query calculation in Framework Manager and that worked well.

Hi

The property I mentioned is available for a stacked chart in Cognos analytics v11 R4 and I think it would be available in earlier releases of v11 as well as this is not a new one. Yes your UI would be different because my screenshot was from 10.2.2 but I posted it to provide an idea.

Creating such query calculations in FM is not a good idea unless you need this requirement to be met in all your reports/charts; you can never get the original product item name if the value is less than 1000. Instead of you do that in report you can still get all info in another report (or a drill through report) in case needed.

Thanks
Kiran

[MFGF]

Hi

The property I mentioned is available for a stacked chart in Cognos analytics v11 R4 and I think it would be available in earlier releases of v11 as well as this is not a new one. Yes your UI would be different because my screenshot was from 10.2.2 but I posted it to provide an idea.

Creating such query calculations in FM is not a good idea unless you need this requirement to be met in all your reports/charts; you can never get the original product item name if the value is less than 1000. Instead of you do that in report you can still get all info in another report (or a drill through report) in case needed.

Thanks
Kiran

The issue here is that charts are not available for use in Cognos Analytics dashboards - only in reports. In a dashboard you only have access to visualizations, and as bscherzer indicated, there's no "Summarize Small Items" option for these.

MF.

[Kiran P]

Ok, got it. Since he did not mention about dashboard I was thinking about reports.

Thanks
Kiran