Calculation of a row value by the Grand total for that selection
Hi!
I have a situation where I need to do a calculation of Allocated amount which is based on a formula like this: Hours of the employee for a particular Project divided by the grand total of hours for that employee for any selected date range and this multiplied by the rate of employment. I am not able to get the Grand Total aligned dynamically against each row so I can use it for my calculation. Basically I have a table like below:
How do I achieve this either in Beast mode or MYSql if its possible, I am not able to get the 56 total to use on my formula.
Help will be greatly appreciated.
Thanks
Answers
-
What you're describing is a window function. If you abstract your problem and google "percent of total" SQL, you'll find loads of solutions.
You'll have to ask your CSM or support to enable "Window functions in Analyzer" but after that
sum(sum(hours_worked)) over () will give you the 56
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Thanks so very much , that resolved my issue.
Thanks
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 469 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive