Hi everyone,
I'm building out a Dashboard for monthly statistics on a Support team and am having trouble with one metric in particular: The amount of tickets that were reopened within 7 days of them being closed, the idea is that if it takes more than a week to reopen, it's more than likely a new issue. I know that I can easily find the number of tickets reopened using the OOTB "Reopen Count" and "Last Reopened at" fields but I can't quite figure out how to filter down to only tickets that were reopened within 7 days. Any suggestions would be appreciated, thank you in advance!
