I am looking to number the rows of my output with four 1’s, then four 2’s etc etc regardless of the value in the rows. My data is sorted by week so I am basically trying to group the weeks into groups of four.
I have tried looking at row_number() but can’t figure out how to do this.
Any help appreciated.
>Solution :
select WeekCode, Revenue, 1 + (row_number() over (order by WeekCode) - 1) / 4 from Data