I’m trying to create a stat reporting dashboard but have hit a couple of snags.
I have two tables - one for individual stat instances, the other for stat types. The former looks up from the latter. I’d like to set up a frequency so that a stat is reported once every x days or months. So, let’s say I want someone to collect the number of newsletter subscribers we have once a month.
To do this, I’ve had the stat type info have columns for a) person responsible for stat collection b) desired frequency c) the date the stat was most recently collected. My problem is in b) and c). For b), the duration column only allows for days, making it difficult to make it a monthly requirement. For c), I am struggling with the formula to get the latest date within the other table that matches the stat type I’m looking for.
Would greatly appreciate any help!
Here’s what I mocked up so far, including my hilariously incorrect formula for determining c: Reporting Dashboard