Explore - Number of tickets per day from a field value

Hi, 

I need to create a report showing when a ticket has changed a value in a custom field from any other value to a specific value.

I.e Ticket 12345678
Enquiry status = Sales enquiry or Lost contact 
The value then changes to 
Enquiry status = Sales active 

I need to build a report that shows for the last 14 days how many tickets moved to 'Sales active' from any other value.

The team want to know I.e:
Monday: 25 tickets moved to Sales active
Tuesday: 26
Wednesday: 30
Etc... 

I've tried several ways to do it and I can't seem to figure it out

Thank you very much in advance for any help given