Aggr Straight Table to Bar Chart

cbaqir — Mon, 26 Jun 2017 19:30:34 GMT

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

Re: Aggr Straight Table to Bar Chart

sunny_talwar — Mon, 26 Jun 2017 19:36:58 GMT

May be try this

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

cbaqir — Mon, 26 Jun 2017 19:40:18 GMT

Thanks Sunny!