Aggregating a column in Beast Mode
Is it possible to aggregate an entire column in a beast mode calculation within analyzer? (I have found videos explaining this within a SQL ETL, but not as a calculated field in analyzer).
For example: In the table below I want to divide the value in the "efficiency" column by the averge of all values in the column. Right now, the "aggregation" column is a calculated field with the formula =AVG('Efficiency'). It returns the value in the "Efficiency" column, so if I were to divide, I would always get "1." But I want each efficiency value divided by 57.14 - which is the average of all efficiency values.
Is this possible with a Beast mode calculation, or do I need to edit the ETL? If I do need to edit the ETL, the card using this aggregation is the third frame of a drill path. Will the path be affected?
Thanks for the help!
Best Answer
-
Within beast mode this isn't possible because you can only do a single group level. Do display the single values and then get the sum of those values would require two separate grouping levels (individual values and entire dataset level). It's possible with a subquery in SQL but not possible in a beast mode.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Hi @rgbuckley,
The calculation below should do the trick:
'Efficiency' / AVG('Efficiency')
Let me know how that goes
Cheers,
Eric
1 -
Hi Eric,
Thanks for reacing out. When I do the calculation you suggest, the calculated field always returns 1, since it is taking the efficiency value divivded by the average of that one efficiency value. I need to aggregate the column before dividing. Thoughts?
0 -
Within beast mode this isn't possible because you can only do a single group level. Do display the single values and then get the sum of those values would require two separate grouping levels (individual values and entire dataset level). It's possible with a subquery in SQL but not possible in a beast mode.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive