I need some assistance in trying to find the best approach to getting the required output from mysql.
I have a table that shows the history of a ticket. Like date change was made, type of change, the new value, etc.
What I need to gather is a running total of the status of all tickets for each day in a date range. So I need to look at the history of each case and count its recent status during that specific day.
The output should produce a table with the following headers and each row should show the total of each header we had for the specific date.
| Date | New | Open | Pending | On-Hold | Solved | Closed |
Right now I can get the total number for each status "created/update" on that day but not the running total of any that were created/updated the day before and haven't been updated since.