Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Sum(Aggr(if(((today()-LAST_REVIEW_DATE)/365)>3.0,1,0),GOVERNING_CCG, DESCRIPTION))
May be try this
Sum(Aggr(if(((today()-LAST_REVIEW_DATE)/365)>3.0,1,0),GOVERNING_CCG, DESCRIPTION))
Thanks Sunny!