-
1. Re: How to compare with color but not add up the two values
Joe Oppelt
Mar 6, 2017 5:26 PM
If it's in the column and you turn on totals for that column, Tableau is going to do what you told it to do.
Create separate calcs:
WINDOW_SUM(IF ATTR([whatever is your color differentiator] = "Order" THEN SUM([this column field]) END)
(And do the same for the refunds in a second calc.)
Or you can also use LOD in the same sort of way.
Then you have to decide how you want to display the two new numbers. (When you say "chart", are you doing a text chart (or crosstab)? Or is it a bar chart? Or line chart? Depending on what you are doing, you have various options to display it.
-
2. Re: How to compare with color but not add up the two values
It's a bar chart. After I create seperate calcs, how do I get them to show on one bar? For example, orders is 20, returns is 4. I want the total to be 20, but I want to see 4 on the same bar chart as a seperate color. Makey sense?
-
3. Re: How to compare with color but not add up the two values
Joe Oppelt
Mar 9, 2017 9:39 AM
1 of 1 people found this helpfulUse the measureNames/MeasureValues method to display multiple values.
In the attached (V8.2) I display two measures. Sheet 5 has them stacked by continent. Sheet 6 has them side-by-side.
-
4. Re: How to compare with color but not add up the two values
Hi Joe, How do I see the sheet you attached?
-
5. Re: How to compare with color but not add up the two values
Joe Oppelt
Mar 9, 2017 11:18 AM
You might not see it if you are accessing this on a phone or just through email. Log into the web site. It's attached to my reply.