6 Replies Latest reply: Apr 2, 2018 2:39 PM by Mark Ritter RSS

    KPI values is empty if any category selected in Bar chart

    Selva A

      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])

       

       

      44.PNG3.PNG

       

      Thanks in advance.

       

      Thanks,

      Selva