Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
i have a dimension "Traffic" in table 1 which has values 'EP', 'PP'
another dimension "Target.Traffic in table 2 which has values 'LP' , 'Retailer'
in front end i want to create a filter "Traffic" which should have only 2 values EP and PP from both tables. (from table 2 wherever its LP it should be 'PP' and wherever Reatailer it should be EP)
how to acheieve this in front end ?
Hi @sanjujeeboy
Please review my proposed solution to your problem; all these steps should be done at the Front-End UI.
=if(Traffic='$(vTraffic)', Traffic)
=if('$(vTraffic)' = 'EP',
if([Target.Traffic]= 'Retailer', [Target.Traffic]),
if([Target.Traffic] = 'LP', [Target.Traffic]))
Exit edit mode and test the new selector.
Some screenshots:
Hope this helps,
Hi @sanjujeeboy
Please review my proposed solution to your problem; all these steps should be done at the Front-End UI.
=if(Traffic='$(vTraffic)', Traffic)
=if('$(vTraffic)' = 'EP',
if([Target.Traffic]= 'Retailer', [Target.Traffic]),
if([Target.Traffic] = 'LP', [Target.Traffic]))
Exit edit mode and test the new selector.
Some screenshots:
Hope this helps,