Forum Discussion
Conditional Formatting Based on Field
Hi,
So I am trying to color code my Card visualization based on a field, so that if the sum of this years data is less than last year for Initiated, the color is Green, else Red
or if the sum of this years data is less than last years data for Repaired, the color is Red, else Green.
I thought this worked, but the color seems to be the opposite of what I want the color to be as shown in the screenshots below... I am not sure why
The actual Card visualization with the measures seem to be correct...
Please let me know if this question is confusing
Thank you!
Anonymous
What is the visual you are using? Is it the KPI visual?
The default card visual works:
If you are using the KPI visual, you need to set the colors in the formatting pane as follows:
4 Replies
Anonymous
Can you put the measures you are comparing in a table to see the results? I can't really tell what is happening from the card visual by itself...
hi! PaulDBrown
So I added a table, for the Total Initiated Leaks This Week, I want the "avg wr#count?" to be less than "avg wr#count? last year" so if it is greater, I would want the 339 to be Red.
for the Total Repaired Leaks This Week, I want the "Avg wr#count?" to be Greater than "Avg wr#count?rep" so if it is Less, I would want the 52 to be Red.
It seems to be working in the "Green" and "Reg" measure and measure 3, but it is not working with the actual numbers....
Please let me know if this does not make senseThank you!
SarahAnonymous
What is the visual you are using? Is it the KPI visual?
The default card visual works:
If you are using the KPI visual, you need to set the colors in the formatting pane as follows:
Anonymous
What conditional formatting you have applied on the datacard?
Regards,
Vivek
