Running total of Count of orders

Question

Show the running total of count of orders. The chart should also display the increase or decrease of order according to color.

Answer 1

Hi Preethi,

Follow the below steps:

1. Create a bar chart with count(orders) and year on the sheet.

2. Now convert the count(orders) and add quick calculation as running total. change the graph to Gantt under marks pane.

3. Now add the -count(order_id) in color shelf.

4. Add the count(order_id) in color shelf with stepped color to show increase or decrease of orders.

Hope it helps.