Trying to display an average of a counts in a text field

@bmasteller you can try level award calculation.
where your partitioned column is date, status

please refer to the links below.

Best
Neelay