How do I add a total to a column when I added a Beast Mode?
I added a Beast Mode so I would only get the Fee to list once since the Position ID is listed multiple times. I need to see each line so I can have a count on how many candidates per position. have I used - SUM(DISTINCT Fee
). It works great, but how do I now get a total for the column?
Raw Data
This is the pivot. Everything looks great except the Grand Total. I want the "Test Fee" to have a correct Grand Total. Can this be done?
Best Answers
-
Hi Kim,
Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.
By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.
0 -
Thanks for reaching out to our community forum.
In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure.Here are the common approaches to achieve this:
- Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
- Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.
0
Answers
-
Hi Kim,
Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.
By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.
0 -
Thanks for reaching out to our community forum.
In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure.Here are the common approaches to achieve this:
- Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
- Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.
0 -
Thank you for the responses! I was able to create the below Beast Mode which solved my issue.
SUM(MAX(
Fee
) FIXED (byPosition ID
))0 -
Great!
I apologize for the misunderstanding. It seems I misinterpreted your use case. I thought you wanted to display a unique row for each position ID with its corresponding fee, along with a grand total for the overall fees.
I'm glad you were able to find a solution that works for you!0
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
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 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