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|
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