Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    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:

     

     

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

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...

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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 sense

     

    Thank you!
    Sarah

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      6 years ago

      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: