This content has been marked as final. Show 2 replies
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.