Stacked Charts: Support Multiple Group Types
Brian Dollen
Currently any chart type is only able to select one field to group by, but in the case of something like stacked charts there's a need to be able to group by multiple values. In the case of the screenshot below, I would need to be able to group by month to generate the X axis, and group by a single select to generate the separated values for the stacked columns.
S
Scott Snyder
I have encountered this limitation today also. You basically need to set up a pivot table and then chart the results. Today, you can do some pivot table construction, so charting should be the next step. In a common use case, you may have a table of Sales Orders that include Amount, Sales Rep, and Order Date. A stacked bar chart or a line chart would be helpful to quickly see performance by month, or quarter of each sales rep as the line rises or falls month to month or quarter to quarter by totalling the sales for that rep. A line chart would have 1 line per rep, and would total sales by period. Stacked bar charts would assign a color to each rep and then stack the colored sections by rep using total sales for each time period. This is an important enhancement to presenting data visually. Tagging Emma Montgomery