-
1. Re: How to compare with color but not add up the two values
Joe OppeltMar 6, 2017 5:26 PM (in response to Alex Martino)
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
Alex Martino Mar 9, 2017 9:17 AM (in response to Alex Martino)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 OppeltMar 9, 2017 9:39 AM (in response to Alex Martino)
Use 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.
-
superstore -- multiple measures.twbx 973.5 KB
-
-
4. Re: How to compare with color but not add up the two values
Alex Martino Mar 9, 2017 11:16 AM (in response to Joe Oppelt)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 OppeltMar 9, 2017 11:18 AM (in response to Alex Martino)
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.