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
46 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

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 Atul
• 5,470 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 28, 2018 in Tableau by Atul
• 10,170 points
569 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 in Tableau by CHERUKURI
• 12,420 points
93 views
0 votes
1 answer

Tableau-donut chart with partitions

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

answered Mar 29 in Tableau by CHERUKURI
• 12,420 points
22 views
0 votes
0 answers

Issues with the Tableau server extracts

A tableau developer had successfully created dashboard ...READ MORE

Apr 20, 2018 in Tableau by Atul
• 10,170 points
30 views
0 votes
1 answer
0 votes
1 answer

waterfall difference chart

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

answered Apr 24 in Tableau by CHERUKURI
• 12,420 points
11 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
897 views
+1 vote
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 8, 2018 in Tableau by Atul
• 5,470 points
28 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.