Best Of
Is there a way to nest beast modes in another beast mode without exposing the full calculation
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.
JustinB
Re: how do you calculate the age (in months) using the date of birthday?
This is what I would use:
ROUND(DATEDIFF(CURRENT_DATE(),`INFANT'S DETAILS:\nDate of Birth`)/ 30.437)
Note that I've also swapped the order of Infants details and Current date in the DATEDIFF() function to avoid a negative number.
Re: Bar chart projection feature
Sadly the documentation about this feature seems to be outdated and does not include information on this option. Based on your screenshots my best assumption is that it looks at which periods have data up to the end of the period and then selecting this box or not determines whether to any actual for the current period should they append any projections for the remaining of the period. Since September only started, most likely you only have a couple of entries up to today for actuals, but the budget most likely has entries going up to the end of the month, so it sees it as completed and therefore it won't project anything for it (the fact that it doesn't projects anything for the months after does seem to be a problem and I'd advise you to open a ticket with support to have it further reviewed, I could kind of imagine if all budget items are entered with the EOM date how that could be causing the system to work on them in a weird way when trying to project).
Re: dynamic date associating
I would need to test this out, but ideally, you could solve this with a variation on @MarkSnodgrass word cloud example (YouTube link), and after exploding to have one row per each associated ID, plus one row for the unassociated version, where you'll Join the data from the associated IDs (only the field you care for), then use a GroupBy tile to get the MAX of the dates for them. This should theoretically work … whether it'll be fast or efficient since you mentioned IDs will be associated with upwards of several hundred IDs that's a different story. Also this approach will only work assuming you only care about direct associations as you mentioned in a comment before.
Bryan Van Kampen Joins the Ranks as the Community's Newest Coach!
👨🎓 Graduating to coach status in the community forum is a monumental achievement! 🏆️ It is a sign of prestige and knowledge that few Domo users can claim to have. Which is why we all need to give @trafalger a massive round of applause for this impressive accomplishment! 👏👏👏 Bryan has been a long participating member of the community forum for over 5 years. Last month alone, he solved 12 questions and finally became a coach on September 1st.
If you'd like to connect with this Domo pro on LinkedIn, click on this link.
Congratulate @trafalger by leaving a comment below!
