Split Days in Date Range for each week within the range

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

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?


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.