Translate this error
Hi,
I am trying to write a weighted average formula into an ETL. I am not sure what this error means. Can someone help me with what the syntax should look like so that I aggregate it properly?
Thanks in advance.
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
@damen This means that your formula is doing an aggregation (your weighted average) but your data is not aggregated. You can think of it as your formula is trying to create one number, but since your data is not one row, it doesn't know what row to put this single value on. If you tried this in SQL Server or MySQL, you would get the same error. Essentially you're trying to do this:
But SQL will try to make the Average value another column but it is only one row/value. So does it put this value on Row 1? Or Row 2? Or another row?
To make this work in ETL, you would need to use the Group By tile, but for what I think you're trying to accomplish, you would want to do this in a beast mode on your card, as the card would be handling all the groupings for you.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
Answers
-
@damen This means that your formula is doing an aggregation (your weighted average) but your data is not aggregated. You can think of it as your formula is trying to create one number, but since your data is not one row, it doesn't know what row to put this single value on. If you tried this in SQL Server or MySQL, you would get the same error. Essentially you're trying to do this:
But SQL will try to make the Average value another column but it is only one row/value. So does it put this value on Row 1? Or Row 2? Or another row?
To make this work in ETL, you would need to use the Group By tile, but for what I think you're trying to accomplish, you would want to do this in a beast mode on your card, as the card would be handling all the groupings for you.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive