Sorting Issue

[ajcaimol]

Hi,

I'm having trouble sorting this graph by week start on Sunday, it always turns up this whenever I use count of day as an anchor, count of day sets value to each day of the week starting from Sunday to Saturday (1-7) respectively so I don't know if there is another way to sort this graph?

[lauratilton · Accepted solution]

So "Count of Day" is a day number related to the day of week? You'll want to use Average aggregation rather than Sum in the Sort. Think of it this way: The average of all the 1's is 1, the average of all the 2's is 2, etc. so this should sort the way you want.

[ajcaimol]

Yes! Thank you so much! I definitely did not think of the aggregation of that field