0 Replies Latest reply: Aug 7, 2013 10:02 AM by sarah_mader RSS

    Date in table only is displayed after select - firstSortedValue

      Hallo!

       

      I'm wondering about my firstSortedValue function...

      In my Project i have a table chart with following Dimensions and Expressions:

       

       

      Dimension:

       

           - SERIAL_NO

       

      Expressions:

       

           - Max({<Date={'<=$(currentDate)'}>}Value_Amount)              

       

                     -> Seems to work fine

       

           - Date(FirstSortedValue(Date,-Aggr(Max({<Date={'<=$(currentDate)'}>}Value_Amount),Value_Amount)))

       

                     -> for some values directly shown, for others i have to select a SERIAL_NO

       

           - Avg({<Date={'<=$(currentDate)'}>}Value_Amount)              

          

                     -> Seems to work also fine

       

      To make this more clear, some screenshots.

      Sry for censored fields, but i rly cant share the project^^

       

      Without Selection, the table chart look like NoSelect.png and after select like selected.png...

       

      The funny is, the Date is correct^^ But why only after select?

       

      Thanks for any help:)

      Greetings
      Sarah