Group By issue
I am doing a group by tile in magic etl. i have different values for different ID's and need to sum up all the values in each ID. For some reason some of the ID's are not summing and I get null in column for the ID. I did formula to make sure all null values before grouping are 0 thinking that would fix it but for some reason I am still getting null for some. Anyone have any ideas why this is happening?
Best Answer
-
Can you share a screenshot of your Group By tile configuration? The ID should be the column to identify the grouping (1), whatever name you want in (2) and the column containing the values with the SUM aggregation in (3). There should also be no need to do any NULL handling for the values to be aggregated.
1
Answers
-
Can you share a screenshot of your Group By tile configuration? The ID should be the column to identify the grouping (1), whatever name you want in (2) and the column containing the values with the SUM aggregation in (3). There should also be no need to do any NULL handling for the values to be aggregated.
1
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 566 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 596 Beast Mode
- 13 App Studio
- 29 Variables
- 595 Automate
- 149 Apps
- 417 APIs & Domo Developer
- 28 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 362 Distribute
- 99 Domo Everywhere
- 261 Scheduled Reports
- 2 Software Integrations
- 97 Manage
- 94 Governance & Security
- 14 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive