1 Reply Latest reply on Dec 7, 2017 7:05 PM by Zhouyi Zhang

    Working with only Start and End Dates in Datasets

    Crystal Ng

      Hey all,

       

      In my dataset, I only have the start and end dates of the activities. Given that I cannot change the structure of the data, I'm just wondering if there is a way to achieve the result below:

       

      Dataset Example:

      ActivityStartEnd
      A1 August 201731 August 2017
      B1 August 201730 September 2017
      C2 September 201720 October 2017
      D1 September 201730 November 2017

       

      Goal:

      To display activities that are active within month, for example, if I select September, it would display activity B, C & D; If I select October, if would display activity C & D.

       

      I've tried to write calculations and use 1 and 0 to indicate whether the activity falls in a particular month, but the issue is I have many months in my data across different years (and I may also look at weeks instead of months), which means I have write a calculation for every single period which is not the most efficient way, given that the every day new data comes in.

      Thanks.

       

      Kind Regards,

      Crystal