30 Replies Latest reply: Feb 29, 2016 8:10 AM by Sunny Talwar RSS

    working fine with straight table but not with kpi's charts

    naveen kumar

      Hello All,

      What making me confuse is i am using same dimension  and same expression in two diff charts (kpis,straight table),but i am getting two diff results

      i mean ..my default when end user open dashboard he as to see all the location aduit score ...which is working fine in both table chart and kpi chart ....

      if he goes feather and select only particular location from the drop down then he should only see that selected location with score ...

      which is working great in table but its not working in kpis charts,

      what i looking is when i select  location, only selected KPI chart  has to show the value the rest kpi chart  needle should be at zero....

       

       

      straight table:

      dimension:LOCATION

      expression:Sum({<ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)(working fine)

       

      kpi chart:(chanderia kpi chart)


      dimension:LOCATION

      expression:Sum({<LOCATION={'CHANDERIA'},ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)

       

      Help me in resloving this task,

      Please find the attachment(data screen short)

       

      thanks

      naveen