Aggr Straight Table to Bar Chart

[cbaqir]

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

[sunny_talwar · Accepted solution]

May be try this

Sum(Aggr(if(((today()-LAST_REVIEW_DATE)/365)>3.0,1,0),GOVERNING_CCG, DESCRIPTION))

[cbaqir]

Thanks Sunny!