Split Days in Date Range for each week within the range

Question & Answer
, , , , , , , ,
1

Hi everyone,
I’ve been trying to solve this without success. reaching out for help. I have my data structured as follows:

ASSIGNEE_NAME TASK_START_DATE TASK_END_DATE Total Hours Working Days Btw Dates Total Hours Per Day
Mike 4/16/2022 5/1/2023 52 271 0.191881919
Laura 2/16/2022 6/2/2022 75 77 0.974025974
Mike 1/6/2023 5/1/2023 88 82 1.073170732
Martha 5/25/2022 6/2/2022 55 7 7.857142857

I would like to create a view that sums the “Total Hours Per Day” for each ASSIGNE_NAME and for each week of the year. So, I will need to compute the weekdays between date ranges per each week and multiply that by the “Total Hours Per Day”

I will add controls for the user to choose month and year to view the results for each week given the controls.

Do I need to create additional columns or restructure the original data before pulling it to QS?
Thank you in advance

2

Sorry can you explain how you want your end data to look like? I guess if you want it per week you’ll need to show all of those weeks in your data.

Is that part of what you are asking for?

3

@breajos

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.