Hi,
I have 3 years daily web visitor data and i would like to view which days of the week have more visitors. I try to clean the data and used the “groupby” node and manage to view by year/ week of the year/ day of the week but it is sorted in a way that shows all the traffice for day 1 of all the weeks before it moves on to the 2nd day of the week .
I want to sort it by week and day as follows
Week 1 day 1, 2, 3, 4, 5, 6, 7
Week 2 day 1, 2, 3, 4, 5, 6, 7
sample data below.
I currently have this table
Year /Day of week/ Week of year/ Sum(Visitors)
2015 1 1 67
2015 1 2 73
2015 1 3 86
2015 1 4 78
2015 1 5 88
2015 1 6 333
2015 1 7 237
2015 1 8 108
2015 1 9 185
2015 1 10 97
I want to sort it this way
Year/ Day of week/ Week of year/ Sum(Visitors)
2015 1 1 67
2015 2 1 73
2015 3 1 86
2015 4 1 78
2015 5 1 88
2015 6 1 333
2015 7 1 237
2015 1 2 89
2015 2 2 434
2015 3 2 189
Thank you in advance