Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages.
For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together rather than calculating the difference between the left two columns. We see the Grand Total difference for this sample dataset is -139.06% but in reality, the number should be 9%.
Can Domo implement a way to calculate the Grand Total instead of summing all the rows?
Comments
-
you'll need to aggregate the data in the beastmode when calculating the variance like below
(sum(
Column
) - sum(Column 1
)) / sum(Column 1
) *100I suspect you may just be doing
(
Column-Column 1
) /Column 1
*1003
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive