1 of 1 people found this helpful
Create a calculated field, HighHR:
If [HR] >= 100 THEN 1 ELSE 0 END
Drag the HighHR field to Rows
Drag the timestamp field to Columns and expand to the day level
For a quick average,
Click the Analytics tab
Drag an average line to table
After reading your response, I feel kinda dumb. I've done that in other reports before! Thanks fir your help.
This forum is great as there are no dumb questions. The experts welcome questions and treat relatively new users like me with respect. Even though you didn't really need the answer to this question, it may help someone else. I have been helped by answers to other people's questions many times.