Beast Mode Calculation in Summary Number
My beast mode formula goes something like this:- SUM (x) / SUM (y)
I am not able to use the above beast mode for my summary number. I am looking to get the average percentages, but the aggregation field is greyed out and I get the message "using aggregation in beast mode formula". Any help will be appreciated. Thank you
Comments
-
Hi @Saketh
You're attempting to aggregate an aggregate which isn't possible within the beast mode and summary number. If you want the average of the percentage you'd need to pre-aggregate your data with a dataflow to then be able to take the average of the percentage.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@Saketh since you are already aggregating it, you just need to ignore the aggregation field and click on Show Formatting Options and then choose percentage for the Display As format. You will then see your summary number as a percentage.
**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.3 -
@MarkSnodgrass - Thank you for the above fix.
Quick follow-up question - would the averages displayed be a weighted average or is it a simple average??
0 -
@Saketh this would just be a simple average since you aren't putting a weight on anything.
**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
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive