11 Replies Latest reply on Aug 31, 2018 8:27 AM by Brad Sheridan

    Conditional bar chart

    Brad Sheridan

      Hey there Community...wasn't really sure how to come up with a title and not even really sure how to ask, but here goes.

       

      based on the image below, I'm having trouble with the right calculated fields.  I've tried Fixed and Include LODs, combining multiple calculated fields, windows functions, etc...

       

      red = no sales in past 3 quarters

      orange = no sales in past 2 quarters

      yellow = no sales in current quarter

      black = >$100 in sales in current quarter

      green = <=$100 in sales in current quarter

      blue = ignore this for now

       

       

      Thoughts???