Trend reporting
Dear SD Helpdesk
I am trying to create a trend report in MySQL. However my SQL skills are nil.
What I am trying to generate is a report which shows
Tickets created today, still open, still overdue, resolved today, closed today.
In the same report to show yesterdays, day before for up to a week.
Sunday to monday.
Is this even possible, if so, any assistance would be greatful.
officeMonkey.kL
I am trying to create a trend report in MySQL. However my SQL skills are nil.
What I am trying to generate is a report which shows
Tickets created today, still open, still overdue, resolved today, closed today.
In the same report to show yesterdays, day before for up to a week.
Sunday to monday.
Is this even possible, if so, any assistance would be greatful.
officeMonkey.kL