Can you please tell us that what types of condition you are trying to use in Color Coding..?
Well, it IS colour coding based on percent of total, but it's colouring ALL the values in each cell based on the percentage value.
Do you mean you want to ONLY colour-code the percentage value itself, and leave the other value alone?
Or something else?
OK, couple of issues then.
1) You can't get the result you want with a text table. Tableau will color all the values in a cell based on the colour coding. you can't get just one item.
2) You can't do a % of total on an already-aggregated value. Tableau has nothing to work with. You need a number that Tableau can aggregate - can you use the underlying field behind the Session Distinct calculation instead?
Yeah point 2 is the issue then, I don't know how to make the calculation an actual parameter.
1. The % shown is calculating the % of sessions using the column table down, so per application build/version
2. But I want the colour coding to work based on % difference (not consecutively) of the table across, so that it highlights any large % differences across application build/version. However right now its working on session count not the % (as per your point 2).
So I need to create a calculation that gives the results of the %, and use that as the colour coding filter...... hmmmm
Hannah, maybe not. I think you can still let Tableau do the heavy lifting on the % of Total calc provided we can get an aggregateable number as the basis of that calc.
What's the calculation behind the "Session Distinct" field?
Its just a distinct count of ids, but that calc is done in the datasource.
I was thinking I might get somewhere with this method: Calculated Field for Percent of Total . But haven't cracked it yet.....
Right-click drag [session_id] to Color and drop it on top of the [Session Distinct] field to replace it.
From the pop-up menu, change the aggregation type from SUM() to COUNTD().
Add the Table Calc to do the % of Total and set the calculation order the way you want.
Does that work?
That has the same result as my original set up:)
This is really tough without the workbook.
What happens if you go into the Color mark and flip the colours so that red is on the left and orange is on the right?