Grand Total shows incorrect aggregation
In the above image, third column is the beast mode which is count(distinct emailname) aggregation. I am getting correct number of unique email counts in row-wise but when it is aggregated for 'Grand Total' it showing different number. I don't why I am getting 1,781,128 counts instead of original total 1,876,229 counts .
Comments
-
Just out of curiousity, do you have any null values in your data (either as used in your card definition or drill path). Not just blank, but actually Null.
0 -
Is it possible that a single email name could be found in multiple categories? When you are using a total row with an aggregate field, the total row simply applies that aggregation to the entire data set. i.e. if your aggregation was MAX(`Revenue`) then the total row would only give you the max value for your entire data set, not the sum of row in the table.
My hypothesis would be that you have duplicate `emailname` in your data set.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Yes , we do have duplicate email address. That's why we go Unique function but when we want to know the 'Grand total' of all unique values in multiple categories.
In domo , how to do sum aggregation for unique values so that we know , sum of unique values in the entire dataset in multiple categories
0 -
Do you use a beastmode to obtain the distinct items? If so I believe the context of application for the Distinct logic is specific to the card that employs the beastmode and not the drill path. Just a possibility to review/confirm.0
-
Try something like this:
COUNT(DISTINCT CONCAT(`Field 1`,`email_name`))
I can't tell what your field names are, but that should give you the total that you want in the grand total row.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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