Help with max and average result in last 24 hours

This is also super helpful,
I appreciate the help!