Skip to Content
0

webi report based on filter

Sep 15, 2017 at 03:26 PM

35

avatar image

Hi

I want to show specific classes in the report when it is weekday and weekend... like on mon, tues, wed, thurs want to show only C1,C2,C3 and on weekend needs to C1,C4 only..

to achieve same I created an object in universe to identify the day and could you please help me to create the filter in webi report to achieve same

regards

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

1 Answer

Best Answer
AMIT KUMAR
Sep 15, 2017 at 05:09 PM
2

try this at report level

Create variable=if(dayname(currentdayte()) inlist ("Saturday" ;"Sunday") and ((Class) inlist ("C1";"C4"))) then "Show" elseif(dayname(currentdayte()) inlist ("Monday " ;"Tuesday ") and ((Class) inlist ("C1";"C3"))) then "Show"

Apply filter in table and select Show

Show 1 Share
10 |10000 characters needed characters left characters exceeded

thanks Amit for the help

Create variable=if(dayname(currentdate()) inlist ("Saturday" ;"Sunday") and ((Class) inlist ("C1";"C4"))) then "Show" elseif(dayname(currentdate()) inlist ("Monday" ;"Tuesday") and ((Class) inlist ("C1";"C3"))) then "Show"

Apply filter in table and select Show

0