2 Replies Latest reply on Feb 20, 2018 6:53 AM by Leandro Nicolás

    Last day of month for each value of a dimension

    Leandro Nicolás

      Hello, I have these records:

       

      ProjectDate
      A2018-02-15
      A2018-02-14
      B2018-02-10
      B2018-02-09
      C2018-02-15

       

      I need to filter the data to only show the last day for each value (A,B,C) for the field dimension "Project".

       

      ProjectDate
      A2018-02-15
      B2018-02-10
      C2018-02-15

       

      I created a calculated field using last()==0 computed along Time and the calculation restarts at zero for every Month of Date..

      It works only for the last day, so it shows projects A and C because they have the same date.

       

      Is it possible to filter for the last day for each value of Project Dimension?

       

      Thanks in advance