Dear Team,
I have an requirement in Tableau to color the pane based on the values in a list report.
I tried coloring the same but was successful only till coloring the measure value. Am a newbee in tableau. Kindly help me on the same.
Attaching the .twbx file for the reference.
Input:
Entity
Name | Limit1 | Limit2 | Limit3 | Measure Date | Value |
Enitity1 | 5 | 10 | 15 | 24/8/2016 | 8 |
Enitity1 | 5 | 10 | 15 | 25/8/2016 | 13 |
Enitity1 | 5 | 10 | 15 | 26/8/2016 | 18 |
Enitity2 | 5 | 10 | 15 | 24/8/2016 | 8 |
Enitity2 | 5 | 10 | 15 | 25/8/2016 | 13 |
Enitity2 | 5 | 10 | 15 | 26/8/2016 | 18 |
Color Logic:
IF
[Value]<[Limit2] THEN "Green"
ELSEIF
[Value]<[Limit3] THEN "Yellow"
ELSE
"Red"
END
My current Result:
Entity
Name | Limit1 | Limit2 | Limit3 | 24/8/2016 | 25/8/2016 | 26/8/2016 |
Enitity1 | 5 | 10 | 15 | 8 | 13 | 18 |
Enitity1 | 5 | 10 | 15 | 8 | 13 | 18 |
Expected Result:
Entity
Name | Limit1 | Limit2 | Limit3 | 24/8/2016 | 25/8/2016 | 26/8/2016 |
Enitity1 | 5 | 10 | 15 | 8 | 13 | 18 |
Enitity1 | 5 | 10 | 15 | 8 | 13 | 18 |
Thanks
Maheshh
