Skip to Content

Webi : Condtions doesnt work on aggregated level

Mar 08 at 10:32 AM


avatar image

I have a scenario with below outcome but business wants certain conditions on report such as: Exclude "Traffic Total" where its 0 or null (Works) and exclude rows where 'Gross ticket conversion" is more then "Traffic Total". I made filter on 'Traffic Total" not equal to 0 and made a variable (=If ([CSRvc Total Tickets]<[Total Traffic]) Then [CSRvc Total Tickets] Else 0) works only when I use calendar days but if I remove calendar days and choose only Site and week than the condition variable does not work because on aggregated level it doesnt work. I am using bex connection to webi.

Results as it is:

Results afer applying filters and creating new variable:

Results after removing calday:

mubvj.png (8.3 kB)
xqewn.png (5.7 kB)
cntqq.png (7.4 kB)
46664.png (5.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mar 08 at 01:52 PM

create dimension variable for Traffic Tot and Gross ticket conversion objects and then try to filter out.

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

This works only if calendar day dimension is selected, if i remove calendar day and use calendar week then it does nt work because it aggregates all the data on week. Traffic and tickets are CKF in bex and use standard aggregation. Is there any possible way that we can put condition in a detail level per day so that even it aggregates on week level than it shows same numbers.

jlett.png (39.0 kB)