Howdy! Our department has started an incentive program. As a result, we need two reports that are a bit more complex than I've built, before. I'm hoping folks might have some ideas. First incentive received if our creative team goes five days without a red/late task. I have a report built to show the status of open tasks at the current time. However, we need something that will show what each day in the past looks like. Second incentive received if each member of our project manager team turns all requests into projects within five days, for five consecutive days. Again, I have a report for this, but not one for showing multiple days. I've attached an Excel document with what my manager asked for, but I'm open to other ideas. Thank you!
Jenny Jenny Hill PacificSource