4 Replies Latest reply on Jun 17, 2016 1:38 AM by Tim Chu

    How to filter out data - select the last day of each month

    David Morrison

      Hi

       

      We have a data set that shows daily a total number of subscriptions

       

      e.g

      1-Jan-2016  : 500,000

      2-Jan-2016 : 500, 099

      3-Jan-2016 : 501,450

      etc

       

      This data set goes back a number of years.

       

      What I want to do is filter the data to the last day of each month  (this is what I am struggling with)

      Once I can do that I will then look to explore the data in various ways.

       

      Can anyone help with this date filtering?

       

      Thanks in advance.