Running total of Count of orders

0 votes
Show the running total of count of orders. The chart should also display the increase or decrease of order according to color.
May 8 in Tableau by Preethi
8 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

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.

answered May 8 by CHERUKURI
• 12,420 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,170 points
69 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,847 views
0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,170 points
1,332 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
898 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
35 views
+2 votes
1 answer
0 votes
1 answer

How to aggregate and count the occurrence of TRUE and FALSE?

Hi, you can do any of below ...READ MORE

answered Mar 12 in Tableau by CHERUKURI
• 12,420 points
47 views
0 votes
1 answer

How to show running average of profit?

Hi, Follow below steps: 1. Create a bar chart ...READ MORE

answered Apr 3 in Tableau by CHERUKURI
• 12,420 points
7 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.