2 Replies Latest reply: Jun 26, 2017 3:36 PM by Sunny Talwar RSS

    Aggr Straight Table to Bar Chart

    Cassandra Baqir

      My straight table is showing the calcs correctly but I can't get a stacked bar chart to display correctly. It's showing the total

       

      I want to show a stacked bar chart that includes how many need review (Last Review Date>1095 days) and how many do not:

       

      Obviously with the bar chart I don't need the Dimensions of DESCRIPTION or LAST_REVIEW_DATE.

       

      This is the expression that isn't working: sum(aggr(count( (if(today()-LAST_REVIEW_DATE)/365)>3.0,1,0), GOVERNING_CCG))

       

      I've tried this a few different ways and can't get it to work. For example, count (distinct DESCRIPTION) = Total Count - Need Review Count.

       

      Attached sample.

       

      TIA!

      Cassandra