20 Replies Latest reply: Jul 14, 2017 7:40 AM by Siddharth Sheshadri RSS

    Filter for date

    Siddharth Sheshadri

      Hi all,

       

      I have an ordered date which I wish to create a filter on.

      The filter should be as follows:

      • This week
      • Last week
      • This Month
      • Last Month
      • Last 3 months
      • Last 6 months
      • This year.

       

      I cannot create a single dimension field for all this, the reason being it won't select all I need.

      For ex: If I select this month, then it should select the components of "This Week" as well.

       

      Could someone please give me a direction as to how I should go about this?