Forum Discussion
Summing values across multiple records based on two separate Date slicers
Hello,
A pet project I've been working on is a resource tracking report based on the hours our team spends on supporting other teams and regions. We are approaching 400 entries for these recorded tasks looking similar to below.
| Task Name | Brief description of the issue | Assigned to | Start Date | End Date | Duration in hours | Team supported | Region | off hours (# of hours) | Planned work |
| Team's Meetings | Daily Standup Meetings | John Smith | 7/24/2023 | 7/28/2023 | 1 | A | North | Yes | |
| Projects | License Reduction | Mary Jane | 7/25/2023 | 7/25/2023 | 0.5 | B | South | Yes | |
| Admin Work | Clean up servers | Luke Skywalker | 8/1/2023 | 8/4/2023 | 3 | C | West | Yes |
We are using two seperate date columns to track the ranges of time during which our different work items are taking place. This is my current roadblock since most date experessions I've seen so far are expecting a range of date entries from a single date column. Our report as of now is using two date slicers to filter work hours based on Start Date and End Date, so I'm curious to see how (if possible) we could perform a calculation that multiplies working hours in a day by the number of work days between two specified dates from different columns. Any help would be appreciated 🙂
2 Replies
Read about NETWORKDAYS() and DAYSBETWEEN()
Hi,
Based on the data that you have shared, show the exact expected result.
