Hey all!
I've been working on trying to get a clear picture of the repeat cycle at Shedd. I am quantifying this as time between visits, and calculating based off of order data using average time (months or days) between the latest and second most recent visit. Wondering if anyone else in the museum world especially has been working with this type of analysis and might have recommendations for how to manage this (particularly any recs on time parameters and nuance on visit parameters!).
Thanks!
Well Chris, it took me a while to sift through the formulas and properly set the filters so I could validate the results. I think I need a nap now, but many thanks for figuring out how to get us to the data. I enjoyed learning your multiplying the attended year by 365 plus the attended day of year method for figuring out the number of days in between the dates.It is still crazy to me that multiplying the year by exactly 365 (# of days in a year - usually) and then adding the Calendar Day of Year makes the math work out properly.
MAX([Calendar Year] * 365 + [Calendar Day Of Year])
It took me a bit to realize that the formula is just converting the Years into Days so that you can compare days to days to compute the difference.