How do I aggregate by groups?


How do I generate agregate subtotals by groups – so that I can have stacked bar charts based on the grouped-by month or quarter along the x-axis?

Hi @TheLF
I’m not quite sure if I understand what you’re trying to do.
Can’t you just summarize “Sum of Price” grouped by “Product Family” and “Purchase Date : Month/Quarter” ?
In version 0.33, you can do aggregation based previous aggregated data. Use the “Ask a question” > “Custom question”.

Hi, thanks – yes, I am trying to show side by side over time Product Family and Sum of Price. It is working now, although not sure what was the problem before.

I think you might have switched what series that was the primary on the x-axis before - you can change the in the visualization settings under the Data-tab