Top 5 Selections within 7 day Rolling Period
I'm creating a dashboard to track complaints filed against a facility. Each record in my dataset is assigned to a unique ID. Each unique record displays 1 "topic" they selected. The "topic" is the reason for their complaint. I need to find the Top 5 Topics selected on each ROLLING 7 day period. So today's 7 day period…
