Issue in total/subtotal of the pivot
SEC_TO_TIME(SUM((End Time
- Start Time
)) - 3600)
I am using the above calculation to get the employees who has exceeded their break by 1 hour. it is working fine in normal condition but when i put this into pivot and checking the subtotal / total, it is just subtracting 1 hour from the total which is wrong. it should just give the total which is like 0:42:00 in the below example.
Supervisor | Employee Name | BE V2 | Duration |
---|---|---|---|
AB | X | 0:02:00 | 1:02:00 |
AB | Y | 0:29:00 | 1:29:00 |
AB | Z | 0:11:00 | 1:11:00 |
AB Total |
| 2:42:00 | 3:42:00 |
Tagged:
0
Answers
-
This is because how your Beast Mode is written, it aggregates everything first and then just subtracts an hour.
What you'll want is (assuming you're filtering for records where the duration is already > 1 hour:
SEC_TO_TIME(SUM(`End Time` - `Start Time` - 3600))
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive