Skip to Content

Webi : Condtions doesnt work on aggregated level

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 08, 2018 at 01:52 PM

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

    Add comment
    10|10000 characters needed 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)