Week Number

Question

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?

Sample data.xlsx

Luke_C · Accepted Answer

Hi @sgaryali

Here's my attempt at this:

* 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). 
* Then I joined the new week number to the data and summarized.

JosephSerpis · Accepted Answer

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.