It’s better if I explained it with an image, but i’m not sure why I can’t add image or links into this post.
I grouped the table according to the field date, and I’m trying to sort the table according to the average value of “quality of the day”
To give you some context, I have different areas in my life i’m trying to track in terms of productive hours, so there’ll be the spiritual work, actual work, and also people (relationships). At the end of the day I’ll rate the date relative to the area of life I’m working on, so then I can after that see the average quality of the day.
The quality of the day field is only from -2 to 2.
I’m trying to sort from highest to lowest so I can see which days I’m at an average of 1 or 2, and I want to replicate those days more in my life.
Any suggestions on how to do this?