Statistics chart Group by - to make in same level
Is there any easy way we can show a chart with 3 Group by Function & 1 Aggregate function at the same level , without Drill down ?
As the requirement is not to drill down , how can we show this type of chart Data at same level ? For the same requirement it is required to show Data for past 6 months which is possible by Group by Month , but when additional 2 Group by is added Report does not stay at same level ?
Anyone has implemented such scenarios and what is the trick to manipulate it ?
I believe you can have two groupings and one aggregate at the same level without a drill down chart - works with line, area, bar charts (standard). But, with more than 2 groupings, it will not offer chart variations and it goes into drill down by default. Sunburst can show you all the groupings (more than 2) in the same level, but will drill-down to another sunburst once you click on any of the groupings except the last level, where it takes to the data. Can you confirm the chart type you are trying to create?
Yes we are looking for a Bar chart , but without drill down , which I think is possible on a Linear chart .Sunburst / Tree map is also a Drill down view which the Users don't like .