3 Replies Latest reply on Nov 7, 2017 7:05 PM by Michael Begg

    Relative date filter | Anchor relative to measure

    Michael Begg

      Hi,

       

      I receive lots of monthly data after the month has finished (e.g. on 8 November, I received data for October).

       

      I would like to use the Relative date filter to show Last 6 months but if I anchor relative to today, I have to include the last 7 months, which is confusing for users.

       

      Alternative, I can anchor to a particular date (31-Oct) but then I have to update this manual input each month.

       

      I can get around this by setting up a new calculated measure that works off a parameter/dimension filter but was hoping to avoid doing this.

       

      Any ideas?