KPI values is empty if any category selected in Bar chart

[selvakumara]

Hi,

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.

Thanks,

Selva

[Chanty4u]

what is the measure in bar chart ?

do you have multiple tables in script?   if yes mention the flag in KPI 

[selvakumara]

Measure :

Count([Re-admit Days]) for Bar charts

[thevingo]

Hi

please check your data-model/script

or try bucket calc in backend-script

[selvakumara]

ok let me try

[avinashelite]

check whether you have any values for the days <=7 [Total Discharges] in this column

[rittermd]

I would not do that calculation in the bar chart.  I would do it in your load script and store the value in a field.  Then simply do a count in the bar chart and in the KPI.

Much more efficient and less code to deal with in the dashboard.