1 Reply Latest reply on Dec 5, 2018 6:21 AM by Jim Dehner

    View for next 2 months

    P C

      I have a parameter date - eg Dec 2018

      Now I want to show a view in which +2 months i.e. Feb 2019 data is shown.

      How can I achieve this  ?

       

      I have added a month filter for M+2 i.e. Feb,

      but I want this to be dynamic, hence can't play around with year as filter.

       

      Please guide.

      TIA

        • 1. Re: View for next 2 months
          Jim Dehner

          Good morning -

          Try adding a filter that looks like this

           

          DATETRUNC('month',[Order Date]>=datetrunc('month',[date parameter]) and

          DATETRUNC('month',[Order Date]<=datetrunc('month',dateadd('month',2,[date parameter]))

           

          where Order date is the date you are using in the viz

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful