Dashboard

jgneely72151

I have a metrics sheet that I send every Monday to leadership. However, I'm finding that I need to look at prior weekly metrics for comparison. Since my metrics sheet updates constantly, how would I capture that data without having to log it manually each week? I know this is a vague question. My formula knowledge is limited so I imagine a formula must be applied. I track the # and % of participants that are compliant, partially compliant and non-compliant accross 3 programs each weekly.

If possible can you provide a simple example and explanation.

I want to build a dashboard that will visually show the current week and at least 3 past weeks to check progress.

Thank you for any guidance!

Paul.Woodward

Hello, @jgneely72151 .

I do not have an exact answer but I wanted to talk it out below. I would LOVE to hear what someone else thinks or their answer

The only thing I can think of is if you have your MASTER Report, and create a sub-report off of it. The sub-report, could be sorted by dates, which would allow you to see the metrics for the selected dates. You could have the master report on the dashboard showing current metrics, and then below that you could have the sub-report displayed or metric widgets / data widgets for the selected dates?

Thoughts?

jgneely72151

Would this date field you mentioned for past report data be a modified date field? I do not track any dates on my master sheet besides participants DOB and a date recorded for when they become compliant. I'm a little lost still because if last weeks metrics was 50% compliant and this week 75%, I want to be able to capture both, except I'd like a running list of past metrics. Right now I am only capturing realtime metrics automatically and manually documenting prior weeks metrics. There has to be a better way.