Looking for any advice suggestions on the following.
First, I wanted to ask, if I make a change to a saved beast mode, and another calculation is using that beast mode will that calculation automatically update?
Second,
I would like to nest multiple beast modes in a calculation and use a case statement to select which beast mode I want to use for a specific set of data. I have about 20 of these beast modes, so my calculation is getting VERY VERY long. In Tableau and other tools, the beast mode would simply show as a field name and would not expand out. Is there any way to do this. I cannot do the beast mode in the data flow as I need the calculations to be dynamic and to adjust to whatever filters the user uses.
Examples:
Beast Mode 1 - CTR:
case when (sum(`Clicks`) / sum(`Impressions`)) < x then 0
when (sum(`Clicks`) / sum(`Impressions`)) < y then 1
when (sum(`Clicks`) / sum(`Impressions`)) < z then 2
else 3 end
Beast mode 2 - Video View Rate:
case when (sum(`Video Views`) / sum(`Impressions`)) < x then 0
when (sum(`Video Views`) / sum(`Impressions`)) < y then 1
when (sum(`Video Views`) / sum(`Impressions`)) < z then 2
else 3 end
I would love to just be able to use a beast mode that has just the field names:
case when objective = clicks then 'Beast Mode 1' else 'Beast Mode 2' end
But instead i see all of the calculations.