I'm running into an issue with tickets that get reopened after being rated, and then solved again. These tickets are then reported against a date when they were Solved for the second time instead of when being rated.

For instance:

1. Ticket gets solved by automation because the customer stops responding. The customer leaves a Bad rating.

2. We reopen a ticket to follow up, and continue working with the customer.

3. The ticket gets Solved again in February.

When we run the report, this ticket will be reported against February CSAT, although the rating was left in January. The CSAT is based on the date of Solving the ticket, not when it was rated.

Is there a way to report only on tickets that got rated in the time frame that we are running a report for instead of basing it on the Solved date?