working fine in straight table but not in kpis chart

[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

[kunkumnaveen]

Hello all,

sorry for  sending the post without attach file

please find the attachment

thanks

naveen

[avinashelite]

Hi Naveen,

Since your hard coded the LOCATION it will always show the results related to that particular location ....try to remove the location set analysis and check ???

[jonathandienst]

No screenshot

I suspect that Max(ADATE) is evaluating differently - for the kpi chart it is getting the max value when the location is selected according to the LOCATION=.... clause of the set expression. The straight table will get the max date across all the (user selected) data set.

[kunkumnaveen]

Hello Avinash,

Thanks for quick response ,i hard coded  the location name so that when i select that particular location from drop down ,only the related kpi chart needle will be up and the rest in my case(debari,zawar) kpis chart needle should show zero.......but still i tried my removing location but result is same

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

Sum({<ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)

thanks

naveen

[kunkumnaveen]

Hello jonathan,

i forgot to attach while posting but in reply i have done please find ..

thanks

naveen

[kunkumnaveen]

Hello

Extension to my above post i am able to achieve my requirement if i select related value from both drop down i mean

                                                                             1.location

                                                                              2.name

but i need the same result by selecting location itself which i am able to achieve by using straight table

please find attachment

thanks

naveen

[avinashelite]

I think the problem is with the MODEL I guess...check how the max date and the LOCATION are associated

[kunkumnaveen]

Hello,

if the problem is with the model,how come its working fine with straight table..u can find my data associated in last slide

thanks

naveen

[kunkumnaveen]

Hello

please find both the attachment

thanks

naveen