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

[kunkumnaveen]

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

[sunny_talwar]

Breaking down the above part into 2 parts:

1) Concat(DISTINCT LOCATION, ', ') -> Concatinating distinct LOCATION names and separating them by a comma. Will give you something like this DEBARI, ZAWAR, CHANDERIA, ..... and so on

2) SubStringCount(DEBARI, ZAWAR, CHANDERIA, ....., 'DEBARI') = 1 -> will count the number of instances we see DEBARI. In this case since we concatenating only a distinct list of LOCATION, we will ever only see just 1.

Now without selection each location will have a 1, but as soon as you make a selection the above if statement will give only 1 for the location selected because concat(LOCATION, ', ') = will show selected LOCATION.

Does the above explanation helpful?