Week Number

[sgaryali]

Hi

I am trying summarize the data on the bases of week number

But I want to Alteryx to start week from Monday to Sunday i.e. (11/01/2021 to 11/07/2021) should be WK45 and (11/08/2021 to 11/14/2021) as WK 46.

So that for WK45 sum of hours should be For Emp id 102 should be - 39.5 which is currently - 31.5

How to do that?

[Luke_C · Accepted solution]

Hi @sgaryali 

Here's my attempt at this:

1. I created a row for each day of the year, and used a multi-row formula tool to assign the week number (it checks if the day is a Monday to increment the weeks). 
2. Then I joined the new week number to the data and summarized. 

[JosephSerpis · Accepted solution]

Hi @sgaryali I came up with an approach if the weekday is Sunday then take the record above (assuming it's a Saturday) weeks value in the row above. 

[sgaryali]

Thank you so much @Luke_C  and @JosephSerpis  both solutions work fine.

Thanks a lot 🙂