Rounding Data within card
Best Answer
-
It'd seem many of your Count and Average columns are being retrieved from actual values from the Dataset your ETL generates, rather than being an aggregation at the card level:
This would explain why you get two entries for the same half hour period for the same account. Ideally any aggregation and calculation that should be dynamic and that can be affected by locally applied filters should not be performed via ETLs but either by using Aggregation on existing fields, or via Beast Modes that do the aggregation and oppertaions needed (like if you need a ratio or the like, you'll do something like
SUM(value1)/SUM(value2)
)1
Answers
-
@MichelleH - No subtotals or aggregated but there are a few beast modes
0 -
@MichelleH - sure! Here is a full table overview - filters are just removing account names, sorting is by account-date-half hour. The beast modes just turn the percentage values into actual percentages '
ABANDONED (%)
* 100'. I have another card just like this one without the half hour field that has no duplicate issues.. so its either the half hour or the average fields that are causing this.. the beast modes are on the other cards as well. Thank you!0 -
@MichelleH - it does, I am going to try to rebuild the entire dataset/etl and see what happens.
0 -
It'd seem many of your Count and Average columns are being retrieved from actual values from the Dataset your ETL generates, rather than being an aggregation at the card level:
This would explain why you get two entries for the same half hour period for the same account. Ideally any aggregation and calculation that should be dynamic and that can be affected by locally applied filters should not be performed via ETLs but either by using Aggregation on existing fields, or via Beast Modes that do the aggregation and oppertaions needed (like if you need a ratio or the like, you'll do something like
SUM(value1)/SUM(value2)
)1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive