Is it possible to split the color by some category within a Waterfall chart

0 votes

I am new to Tableau and recently I found out how to create a waterfall chart (Gantt-charts, rolling sum for y-axis and negative value for length of bar.

Now my question would be if there is a possibility to split the color by some category?

Following is the sample of the visualization I want to create within Tableau

Without Split:

Waterfall without split

With Split:

Waterfall with split

Apr 12, 2018 in Tableau by ghost
• 1,790 points
1,457 views

1 answer to this question.

0 votes

It's a very easy task to do. Its as simple as dragging the field to Markscard Shelve(Color), and then adjusting the table calculation.

Step 1: For a simple running sum (for positioning the bars), you have to go and edit the table calculation, and  select Compute using Advanced

Step 2: Drag all your fields to addressing.

Step 3: Sort your data by the master field (in your case the one that has Coffee, Coke,...) maximum (ascending or descending, doesn't matter)

This way it guarantee that the running sum is being applied to one category at a time (not one color at a time)

For more information you can go through the following link: http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#calculations_tablecalculations_understanding_addressing.html

answered Apr 12, 2018 by xyz
• 1,560 points

Related Questions In Tableau

0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in the ...READ MORE

answered May 17, 2018 in Tableau by Mathew1810
1,362 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,240 points
2,549 views
0 votes
1 answer

Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 10,240 points
1,426 views
0 votes
1 answer

Is it possible to change the order of parameters in the dashboard?

Yes it is possible, you can try ...READ MORE

answered May 17, 2018 in Tableau by Abraham1990
781 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
9,780 views
0 votes
1 answer

Tableau chart with mixed colors

It is as simple as dragging the ...READ MORE

answered Jun 28, 2018 in Tableau by ffdfd
• 5,550 points
1,902 views
0 votes
1 answer

Adding colors to a cell in Tableau

Yes its possible, Your logic will only color ...READ MORE

answered Aug 30, 2018 in Tableau by Atul
• 10,240 points
5,799 views
0 votes
1 answer

waterfall difference chart

Hi Sindhu, Follow below steps: 1. Add sales and ...READ MORE

answered Apr 25, 2019 in Tableau by Cherukuri
• 33,030 points
636 views
+1 vote
1 answer

Is it possible to access or install tableau desktop insde tableau server?

Try to understand this, Tableau Server and ...READ MORE

answered Mar 30, 2018 in Tableau by xyz
• 1,560 points

edited Mar 30, 2018 by xyz 825 views
0 votes
1 answer

How to split or divide the grouped data into multiple graphs?

One of a simple approach is to ...READ MORE

answered Apr 17, 2018 in Tableau by xyz
• 1,560 points
781 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP