4 Replies Latest reply: Jun 26, 2013 10:40 AM by Ingo Hüser RSS

    Only values associated with most current loaded date

    Ingo Hüser

      Hi there,

       

      I am desperately looking for a solution to this issue: I want to filter only for those values associated with the most current loaded date. For example when 1st March 2013 ist the most current date loaded, I want to filter for only those values associated with this date. The result should look like this:

       

      date                    value

      01-03-2013          A

      01-03-2013          C...

       

      I tried it with max(date) and firstsortedvalue(date,-date), but this brings up ALL values with their most current dates like this:

       

      date                    value

      01-03-2013          A

      01-01-2013          B

      01-03-2013          C...

       

      Does anyone know how to solve this issue in script or charts? Thanks!