This content has been marked as final. Show 6 replies
I have Bar char and KPI.
Initially the KPI shows total number but if i selected any of the particular category if always shows zero.
Can you please help me on this.
Bar chart expression :
=if([days] <=7, '0-7 Days'
,if([days] <=30, '8-30 Days'
,if([days] <=60, '31-60 Days'
,if([days] <=90, '61-90 Days'
, 'Over 90 days'
KPI Expression : SUM([Total Discharges])
Thanks in advance.