4 Replies Latest reply on Dec 3, 2018 8:08 PM by Wahyu Kusumawardani

    How to get the latest data of every quarter?

    Wahyu Kusumawardani

      Hi,

       

      I would like to create a filter to get the latest data of every quarter.

      This is the example of data

       

      Project     |    CreationDate
      -------------  -----------------------

      Project A  |    1 January 2018

      Project A  |    10 January 2018

      Project A  |    13 January 2018

      Project A  |    2 February 2018

      Project A  |    20 June 2018

      Project A  |    3 September 2018

      Project B  |    3 January 2018

      Project B  |    10 May 2018

      Project B  |    3 June 2018

      Project C  |    3 February 2018

      Project C  |    2 May 2018

      Project C  |    3 June 2018

      Project C  |    10 December 2018

       

      The expected output:

      Project     |    CreationDate
      -------------  -----------------------

      Project A  |    2 February 2018

      Project A  |    20 June 2018

      Project A  |    3 September 2018

      Project B  |    3 January 2018

      Project B  |    3 June 2018

      Project C  |    3 February 2018

      Project C  |    2 May 2018

      Project C  |    3 June 2018

      Project C  |    10 December 2018

       

      How is the calculation field for creating this filter?