7 Replies Latest reply: Mar 15, 2016 6:32 AM by naveen kumar RSS

    need hell in writing expression

    naveen kumar

      Hello All,

      my requirement is i need to display current , previous score and there respective quarters for all the location..

      to achieve this i took bar chart

                                    dimension: location,quarter

                                  expression:current score: FirstSortedValue(OVERALL_SCR,-ADATE)

                                                    previous score:FirstSortedValue(OVERALL_SCR,-ADATE,2)

                    by writing this i am getting messed up bar chart (slide 1)

                      

      later i replace the expression:

                  current score:Sum({<ADATE={"$(=max(ADATE))"},YEAR=,QUATERS=,name1=,ENSTEHDAT=>}OVERALL_SCR)

                  pervious score:Sum({<ADATE={"$(=max(ADATE),2)"},YEAR=,QUATERS=,name1=,ENSTEHDAT=>}OVERALL_SCR)

      i got some wired out put (slide 2)...


      last time by writing the second expression(sum()) and adding two dimension it worked out perfectly ,but only thing was see the location fields last time it was only a single field but now it is a common key field,is that because the sum() expression is not work?


      please help in writhing down proper expression...