Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
yes i have done that