@bmasteller you can try level award calculation. where your partitioned column is date, status
please refer to the links below.
Best Neelay