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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive