3 Replies Latest reply on Oct 26, 2018 6:45 PM by Yuriy Fal

    Use different colors to indicate increase or decrease in values

    Muneeb Mansoor

      Hey guys,

       

      Been banging my head on the wall for the past 2 hours trying to figure this one out. So I have two dollar values across two time periods (Q3 2018 and 1H 2018) and I'm trying to show the direction of change using two colors. Here's where I'm at right now:

      I've already tried using a calculated field to determine the difference between the two values for each category:

      SUM([Full kVA]) - LOOKUP(SUM([Full kVA]),-1)
      

       

      When I put this on the color shelf, I get a blended color that goes from red to green or vice versa. How do I get the entire line to show in one color depending on whether the value has increased or decreased in 3Q 2018 compared to 1H 2018? Thanks for any help you can send my way.