Skip to Content
avatar image
Former Member

rolling 12 month questions

Hi Guru

Is there a way to create a dimension or other date range filter allowing me to return results based on a rolling 12 month period?

For example, I’m returning the prior 12 months and current month-to-date usage, e.g. sep 2016-sep 2017. However, I’d like to change this so that I return prior 11 months (eg dec2016 to Oct 2017) and current month-to-date?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 21, 2017 at 09:32 AM

    follow these steps if you are on Bi 4.1 SP04.

    create variable

    V 12 month back date=ToDate(FormatDate(CurrentDate();"dd/MM")+"/"+FormatNumber((Year(CurrentDate())-1);"###");"dd/MM/yyyy")

    create another variable.

    Show/Hide=if([your date object] between ([V 12 month back date];currentdate())) then "Show" else "Hide"

    Apply filter on table where Show/Hide variable where equal to Show to restrict data for 12 months

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 08:21 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2017 at 07:04 AM

    Thanks @amit.kumar71

    is it possible to achieve rolling 12 months data based on user response in webi .

    as per my understanding we cannot create User response at webi level .

    please correct me if i am wrong .

    Thanks,

    Anuraag

    Add comment
    10|10000 characters needed characters exceeded