3 Replies Latest reply on Oct 5, 2016 4:41 PM by Bhag Ram

    Data extract with dynamic filters

    Bhag Ram

      Hi - I have a live connection of daily data that I want to subset applying filters, so I can use the subset data in my workbook sheets.

       

      The main objective is to reduce the data size before using it in workbook.

      I want to create this subset such that it keeps records that are:

      1. Last day of every month

      2. Most recent day of the current month (this should update dynamically)

       

      For example if today is August 15 and my data has daily data from June 1, 2016,  then the subset should have June 30, July 31 and August 14 records.

      When I look at it t'row, the subset should have June 30, July 31 and August 15 records.

      When I look at it on Sep 5, the subset should have June 30, July 31, August 31 and Sep 4.

       

      I hope the above is clear. I used the data extract filter and hardcoded the end of month dates, but that is not dynamic for the most recent date of the current month obviously.

      I plan to publish this subset source and the corresponding workbook and would like to use data like I show in example above..

      Can this be done at all? Any suggestions or solutions would be much appreciated.

       

      Thank you!