Hi Everyone,
Say I have this as the source data:
Time OrderID Category
1AM ORD-123 Furniture
2AM ORD-124 Supplies
3AM ORD-125 Furniture
4AM ORD-126 Furniture
I would like to turn that into a time series chart like this, that shows running total of each category
I would appreciate any suggestions.
Thanks,
Bob
Hi Bob,
You can add a running total of orders over time using a table calculation.
To create a chart similar to the one you've sketched, I would put the Order ID pill on the Rows shelf, switch it to Measure (Count Distinct), and add a table calc for Running Total. It will default to calculating a running total across the table, which is what you're looking for.
Your viz might start to look something like this (given your sample data):
Hope this helps!
This is exactly what I am looking for. Thank you so much Dara!
Time to look up about table calculation. So much to learn in Tableau!