How do I get the summation of a group of numbers to display?
The table below is a breakdown of the top table -- and it should be displaying the same information.
Could anyone help me understand why this is happening?
Here is one of the Beast modes I'm using for this calculation.
(Top table) It seems to me that I'm only getting one rows worth of data being displayed instead of the summation of the group.
Answers
-
It looks like you are building a pivot table. You want to make sure that you remove any fields not directly listed in your "rows", "columns", or "values" section from the Sort section of the card analyzer. Make sure that you only sort by fields that are also being shown on the card.
1 -
Thanks for your comment @ST_-Superman-_ .
I have removed all or any filtering and I'm not seeing any difference.
0 -
You may want to try adding an else statement to your beastmode then.
Something like this:
CASE WHEN `location_completed_timestamp` IS NOT NULL AND `count_id` = MAX(MAX(`count_id`)) OVER (PARTITION BY `cyclecountgroup_id`, `storagename`, `sap`) THEN `actual_quantity` ELSE 0 END
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 779 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive