I am using Cognos Analytics 11.0.11.
I have a pie visualization that shows percentages of sales for three categories (e.g. golf ($70), soccer ($20), baseball ($10), therefore 70%, 20% and 10%. I have a filter at the top of the page that allows you to filter by region. When you select a region, it displays the percentages as a total of all regions, and not of the region selected.
For example, if the Northwest region makes up 50% of the sales, then the percentages of products will be out of 50%, and not out of 100%, even though I'd like to see the Northwest region's sales out of 100%. If I use "for region" in the data item then it's accurate by region, however when showing all regions it displays the pies out of 300%.
Any ideas on how to address this? Hopefully my description is clear...
My idea right now is a data deck which filters by region, which will work, however I'd like to figure out a different way.
Any ideas?? The only solution I can think of that would work is a separate deck for each visualization that I want, however based on my report this would mean 16+ decks, so I'm not going to proceed with that method due to the upkeep that would be required, and room for error.
Are you still struggling with your report?
I cannot know for sure what you might be missing, but here are some suggestions:
- Check that the measure you show in your pie shows % for region (and not % for report)
- Make sure you added your region as extra category in the pie chart
- Make sure you're not missing any "Interactive Behavior" (set filter based on the region chosen) for the pie
Anyway, I created a small example if none of the above works
This is how it looks: http://imgur.com/a/ww5dt0s
I've attached the report specification.
I used test data, feel free to test it in the public test environment (https://ibmcaoctrial.bi.ibmcloud.com/bi/?perspective=home)
Good luck!
Quote from: rteruyas on 24 Sep 2018 02:19:04 PM
Are you still struggling with your report?
I cannot know for sure what you might be missing, but here are some suggestions:
- Check that the measure you show in your pie shows % for region (and not % for report)
- Make sure you added your region as extra category in the pie chart
- Make sure you're not missing any "Interactive Behavior" (set filter based on the region chosen) for the pie
Anyway, I created a small example if none of the above works
This is how it looks: http://imgur.com/a/ww5dt0s
I've attached the report specification.
I used test data, feel free to test it in the public test environment (https://ibmcaoctrial.bi.ibmcloud.com/bi/?perspective=home)
Good luck!
Thanks for the info. I didn't realize that there was a test environment out there, so that's really cool! I ran your report, and the percentages in the pie upon initially running it add up to way more than 100%, and then they add up to 100% once filtered for country. I was able to get to that point as well, however I am trying to make sure they add up to 100% when looking at all, and 100% when looking by country.
I think I may do a deck, or change how/what information I'm displaying.