Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Attached is my example. I have set some variables with the set that I need to include in the set analysis. I can use them individually in the Static column as you can see, but when I try and make it based on what is in the Base field I can't get the syntax working. Anyone got any ideas?
Just to be clear, when a user selects USA I want the vUSA variable to be used in the set analysis which would give {'USA'}.
Thanks
Gareth
Hi Gareth:
Try this expression for Choice:
=Sum(Visits) / Sum({<Country={$(=Replace(Concat(DISTINCT Choice, ','), ' + ', ','))}>} TOTAL Visits)
Logic: Have been extracting the unique "Country" values and using that list in Set analysis.
Thanks,
Narasimha K
Hi Gareth:
Try this expression for Choice:
=Sum(Visits) / Sum({<Country={$(=Replace(Concat(DISTINCT Choice, ','), ' + ', ','))}>} TOTAL Visits)
Logic: Have been extracting the unique "Country" values and using that list in Set analysis.
Thanks,
Narasimha K
Thanks mate this works a treat!