5 Replies Latest reply on Mar 31, 2017 5:13 AM by Alex Braun

    How to conditionally format a stacked bar chart based on a threshold value

    raghavendra N

      Hi

       

      Is it possible to conditionally format a stacked bar chart based on two different values. I tried the below calculated field but I am getting only records which are greater than the threshold value.

       

      If SUM([Number of Records]) > [Threshold]) then "RED" ELSEIF SUM([Number of Records]) < [Threshold] then "GREEN" END

       

      I am looking for something like below. Where 1-5 are categories.

       

       

       

       

      What I want is , Say if Category A has 50 and the threshoid is 10 ,  The chart should be like the Thresold limit should be Green and then Red for the exceeding value.

       

      Any help on this would be really helful.