5 Replies Latest reply: Mar 3, 2016 4:05 AM by Manish Kachhia RSS

    tying to get max date using first sort value

    naveen kumar

      Hello All,

      my expression was working fine till yesterday ,but not now .....

      i am trying to get max(date_of_ review)  =TOTAL_SCORE value....for each individual  to achieve that i wrote

       

                                                           in a       stright table:

                                                                       dimension:name1

                       expression:FirstSortedValue({<ROLE={'SELF_EVAL'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

      in my date   AMIT INDUSTRYS Score occurs three time ...i want to show only this latest DATE_OF_REVIEW AND

                                                                                                                   second latest  DATE_OF_REVIEW

      in two diff columns in a stright table ...

      but by writing above expression i am getting all .....insteady of those two

       

       

       

      please find the attachment

      naveen