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.
R
Rebecca Kempfer
I'd also love to be able to be able to group by more than one field in a simple column diagram. The use case would be similar to Scotts. I would like to visualize how many Leads got closed in the categories "won", "lost" and "uninteressting" in each week. By using the simple column diagram, I would hope to see 3 columns per week, that get different colors.
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