Skip to Content
avatar image
Former Member

How to restrict webi report data by default to Last 7 day

Hi ,

I would like to restrict by default to last seven days data based on created date feild in webi report . we don’t have universe access. webi report by default to certain period (max(created date) to last 7 days etc) .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 01 at 07:48 PM

    Hi,

    Try this:

    =RelativeDate(Max([CreatedDate]);-7)

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • May 02 at 12:54 PM

    create Show/Hide variable as:

    =if([CreatedDate] between (RelativeDate(Max([CreatedDate]) in report;-7);Max([CreatedDate]) in report ) then "Show" else "Hide"

    Filter on Show/Hide variable where equal to Show.

    Add comment
    10|10000 characters needed characters exceeded