Reporting on "Repeat Issues"

I would like to report on the rate of “repeat issues” we receive on a week to week basis in our project. I would like to have a total weekly and monthly count, as well as a timeline view to compare previous time periods.

I’m trying to keep the report simple for now, as the definition of a repeat issue can get complex; below are the criteria for an issue qualifying as a repeat:

  • If the issue is in a closed status
  • If another issue exists that was submitted within 1 week of it, AND said issue has the same customer request type and the same reporter

Thank you!