How to create a waterfall chart in tableau?

0 votes
How to create a waterfall chart in tableau? how to show profit over each month for each category for each year?
Mar 26 in Tableau by Anitha
32 views

1 answer to this question.

0 votes

Hi,

Follow theses steps:

1. Select profit and order date and make a bar chart.

2. Convert profit to running total from quick table calculation, as waterfall model is formed on running totals.

3. Now select Gantt Bar from the Marks pane.

4. Add the grand total from analytics pane.

5. Add a calculated field, to get the bar size of profit for month as -SUM(Profit) and drop it in size shelf to get the size of profit/loss

6. Now add grand total to the chart.

7. Now add the category to color shelf.

Hope this helps you.

answered Mar 26 by Cherukuri
• 17,870 points

Related Questions In Tableau

0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
491 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

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

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

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

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
108 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,240 points
1,360 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,240 points
50 views
+2 votes
1 answer
0 votes
1 answer

What is pivot in Tableau? how to create a pivot?

HI, When the data required is present in ...READ MORE

answered Jun 12 in Tableau by anonymous
• 17,870 points
14 views
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 17,870 points
148 views