Help Creating New Column From Summing Another Column
Hello,
What I am trying to do seems pretty straighforward, but due to my lack of knowledge/experience, I am having a hard time getting it.
I have card that displays the total contract value of of projects assigned to a particular project manager/employee for a given time period. My goal is to create a new column that displays what percentage of the total current contract amount for the whole company each project manager/employee is currently assgined. The issue lies in the fact that I currently do not have a column/measure summing up all current projects by their contract values. So essentially how can I sum the entirety of a column for a given time period in order to use that value for other equations?
My card looks something like this....
Project Manager | # of Jobs | Original Contract Amount | Current Contract Amount |
Jim Smith | 16 | 7,099,960.15 | 8,476,897.67 |
Steve Smith | 21 | 7,963,172.00 | 8,392,763.00 |
Joe Smith | 18 | 7,561,849.40 | 7,733,761.86 |
Comments
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 820 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive