-
1. Re: Tableau conditional formatting (per column) but separately per dimension category
Matt LuttonJul 11, 2018 9:59 AM (in response to Piotr Konopnicki)
Sounds like a Table Calc might help here -- how familiar/skilled with Table Calculations are you?
Basically, you'd need to operate your calc within the pane, using some sort of WINDOW_ function, but that can get tricky if you're not sure what I'm talking about:
-
2. Re: Tableau conditional formatting (per column) but separately per dimension category
Tushar More Jul 11, 2018 10:35 AM (in response to Piotr Konopnicki)Hi,
Different ways to do this. Here is my approach based on pivot.
Create a calculated field to color.
Place this to color. You can make it continuous to get a sequential color range.
Let me know if that helps or not.
~Tushar
-
example formatting.twbx 17.1 KB
-
-
3. Re: Tableau conditional formatting (per column) but separately per dimension category
Piotr Konopnicki Jul 12, 2018 6:55 AM (in response to Piotr Konopnicki)As I'm not sure if I was understood correctly (probably partially), that's why i constructed this awesome excel example of what I mean:
Measure1 conditional formatting is what I have now
Measure3 to the right is what I want to achieve
So I want to use conditional formatting (not discrete!) dividing it per GROUP or any other category I might have. so this formatting is set separately for group A, B and C.
In example Measure1 you can see that it's just one conditional formatting and number 1 has most red color, number 75 has most green color.
In Measure3 example this is different. For group A number 1 is red, 60 is green, but in group B, as the lowest nubmer is 50 - this number is red, and 52 as a max - is green.
Thanks in advance!
PS - i cant use pivot tables and I must have this dynamic, not choosing colors for each number separately
-
4. Re: Tableau conditional formatting (per column) but separately per dimension category
eva_lesny Jul 12, 2018 7:03 AM (in response to Piotr Konopnicki)-
example formatting.twbx 26.8 KB
-
-
5. Re: Tableau conditional formatting (per column) but separately per dimension category
Piotr Konopnicki Jul 16, 2018 4:34 AM (in response to eva_lesny)Wow, this really is a workaround haha..
It works! Thanks. One more question - how to change values to percentage while they are a text value?
-
6. Re: Tableau conditional formatting (per column) but separately per dimension category
eva_lesny Jul 16, 2018 5:07 AM (in response to Piotr Konopnicki)Glad I could make it work
What exactly do you mean, change to percentage while they are text?
Do you mean tableau reads it as text (ABC) from your datasource?
Or do you want to show it as percent of total?
Or...?
-
7. Re: Tableau conditional formatting (per column) but separately per dimension category
Piotr Konopnicki Jul 16, 2018 5:37 AM (in response to eva_lesny)I have few metrics, lets say one is Clicks and one some kind of aggregation like clicks / impressions, so I wanna show the second metric as a % format and not numeric