Bar chart with more than 2 dimensions - Alternative approaches?
I understand that in Sense we cannot have a bar chart with more than two dimensions. I have a requirements whereby we want to show the annual breakdown of things by two different categories, lets call them Primary and Secondary
So we have a dimension of years, grouped bars to show the volume of the Primary dimensions for each year, and then would like to see these bars stacked, to show the volume of each secondary dimension for each primary
I don't believe this is possible, with us limited to a max of 2 dimensions. Anyone got any suggestions of how to represent the above in a chart, or a number of charts with an alternative approach?
Re: Bar chart with more than 2 dimensions - Alternative approaches?
It looks like you're more interesting in how A-B-C compare against each other then Year on Year comparisons. So you could create a calculated dimension like Year & '-' & Primary to create a single dimension with values like 2016-A, 2016-B, 2016-C, 2017-A etc.
The treemap can use more dimensions, but it may be hard to read. And of course there's always the simple table, or the pivot table.