expression going wrong in kpi

[kunkumnaveen]

Hello all ,

i am trying to show current score in guage chart

expression :=If(SubStringCount(Concat(DISTINCT LOCATION, ', '), 'CHANDERIA') = 1,FirstSortedValue(OVERALL_SCR,-ADATE), 0)

and in presentation tab

under

text in chart:

=If(SubStringCount(Concat(DISTINCT LOCATION, ', '), 'CHANDERIA') = 1,FirstSortedValue(OVERALL_SCR,-ADATE), 0)

both the expression giving me the wrong answer

i am getting 41 as current score(wrong answer)

it has to be 71 (correct)

wat going wrong please help me

[kunkumnaveen]

HI,

Thanks for you ur help ,it worked .......appreciated,

i am sorry for annoying  you ,i need a last help from you

i am trying to display current and previous scores for each location  in a bar chart which i have done,

expression :firstsortvalue(overall_src,-ADATE)(CURRENT )

                  firstsortvalue(overall_src,-ADATE,2) (PREVIOUS)

But my client also need respective quarter with those scores,i thought it will be easy because i got quarter field ..and i added it as second dimension ....

after adding that it is showing all the quarters for all location...

what i need is only current and pervious quarters for all location

[sfatoux72]

It's perhaps better to create a new question.

You will have more answer and It will be better for other people with same issue to find it.

[kunkumnaveen]

yes i have done that