We're working on the backup report card report. We use it to review backups looking back 1 week at a time. Because of the large number of clients in our environment the report is very long and contains only a few failures. We're trying to filter to only show clients that have had failures in the last 7 days. If we filter on status contains "failed" it shows each day as either white or red. If all jobs on that day for that client failed then it shows red. If all the jobs didn't fail it shows as white, instead of half green and half red.

Is there a way to get the report to show either red, green or half green/half red. I.e. we don't want to seen any lines which are all green for the last 7 days.