Skip to Content
0

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

May 01 at 03:16 PM

77

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jyothirmayee A May 01 at 07:48 PM
0

Hi,

Try this:

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

Thanks,

Jothi

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Jothi,

I tried this but its not working

0

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

0
Former Member

Hi Jyoti,

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

0
AMIT KUMAR
May 02 at 12:54 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Former Member

HI Amit,

Thanks! i got the solutions

1