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?
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.
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.
Unfortunately, the beast modes will expand out when you include them in another beast mode. I agree that it would be really helpful if they did not do this, as it would make the code a lot cleaner and more efficient.
I'm not sure if it has been submitted in the Ideas Exchange section of the Dojo, but I will definitely vote it up if you posted it there.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
You could abstract the core calculations in a dataset view and then use that as a field in your beast mode. It's not ideal and abstracts the logic to multiple places. I've been requesting beast modes behave like actual variables for a while now instead of inserting the entire formula.**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
@GrantSmith Not sure that will work as the calculation will be at the level set in the view rather than dynamic and changing based on the chart/filter selections0
@MarkSnodgrass is correct there is no referential way to refer to pre-defined beast modes.
@JustinB you generally should not nest aggregations inside a CASE statement.
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
Unless people think this through really carefully, it usually yields unexpected results. For that reason, Grant's recommendation to embed the math inside a DSV is a strong recommendation; however as you point out, then the data stops responding to filters b/c the DSV is rigid and doesn't give access to the underlying data to filter.
It's kind of a rock and a hard place. And arguably the weakest feature of Domo's Analyzer engine.Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
I used to work with another application, and in this application it was possible to nest calculations, the problem is that depending on the levels that you will nest, the tool had to recalculate all the information, which had a negative impact on performance, I think this is the reason of which it is not possible in DOME to nest calculations.
I dont think this will became an option0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 80 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive