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



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



      1-Jan-2016  : 500,000

      2-Jan-2016 : 500, 099

      3-Jan-2016 : 501,450



      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.