Tableau chart with mixed colors

0 votes

I started working with Tableau and found out how to do waterfall charts (Gantt-charts, rolling sum for y-axis and a negative value for the length of the bar. 

What I want?

Split the colour by some category? 

Here is a sample of what I want, the first one without a split by a category and the second one with a split by category.

Waterfall without splitWaterfall with split

Jun 28, 2018 in Tableau by ghost
• 1,790 points
1,982 views

1 answer to this question.

0 votes

It is as simple as dragging the right field to Color, and adjusting the table calculation.

If it's a simple running sum (for the positioning of the bar), you need to go edit the table calculation, select Compute using Advanced..., then drag all fields to addressing. Then you need to 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 you guarantee that the running sum is being applied to one category at a time (at not one color at a time or something like that).

It's really important to understand the concept of table calculations so you can understand what's going on, how Tableau is calculating stuff. Read this http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#calculations_tablecalculations_understanding_addressing.html

And if you actually understand what you're doing, it's easier to find a solution. For instance, this hack of Gantt Chart to make a waterfall. What goes on rows the chart will understand at starting point of the data, and what goes on size is, well, the size of the chart. You put negative values cause you want the bar to go down. That being said, dragging a field to color won't mess up with the size, but it will mess up with the running sum used to determine the starting points. How to solve it? make it calculate all the colors together. How to make it? Understand table calculations and reach my solution.

This is the simple approach, if your database or fields have some peculiarity, this might not work perfectly, and you'll need to explain so I can try to understand how to solve

answered Jun 28, 2018 by ffdfd
• 5,550 points

Related Questions In Tableau

0 votes
1 answer

Creating a dual axis chart with same measure in Tableau

Yes, this is possible. Drop the measure in ...READ MORE

answered May 29, 2018 in Tableau by Atul
• 10,240 points
8,788 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
21,255 views
0 votes
1 answer

Tableau-donut chart with partitions

Hi Sindhu, Follow these steps to create different ...READ MORE

answered Mar 29, 2019 in Tableau by Cherukuri
• 33,030 points
1,602 views
0 votes
1 answer
0 votes
1 answer
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
732 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,945 views
+2 votes
1 answer
+2 votes
1 answer
0 votes
1 answer

Issues with the Range value in Tableau

One of the best solution is to ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
1,233 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