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

[former_member397701]

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) .

[amitrathi239]

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.

[former_member397701]

HI Amit.

Thanks for giving for response. But in my scenario last seven days only restrict like 05/02/2018 08:10:55 PM to 04/25/2018 12:00:00 AM

In above function i used the data showing is 05/02/2018 08:10:55 PM to 04/24/2018 08:10:55 PM

please suggest me any alternate solution include timestamp control also

[former_member397701]

HI Amit,

Thanks! i got the solutions

[jyothirmayee_s]

Hi,

Try this:

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

Thanks,

Jothi

[former_member397701]

Hi Jothi,

I tried this but its not working

[jyothirmayee_s]

Hi,

What is your [CreateDate] format?. does it show timestamp along with date?.

if not, create a variable to show the timestamp;

Formatdate([CreateDate];hhmm)

and use Amit's formula or my formula.

Thanks,

Jothi

[former_member397701]

Hi Jyoti,

Thanks for giving response, i used Amit formula and got the solution.