Help with some queries Total work log time
Hello,
I m trying to build some MySQL queries around the incident requests could you please assist :
1- a query that can be ran weekly and get the sum of the tech time elapsed for all the tickets worked ( weekly total for the last 4 weeks )
2- top five ticket for specific techs that contain the highest total amount of work log time for the last 6 days
3 - top 5 categories and number of tickets for each cat for last 6 days
4 - total amount of ticket worked the previous week (all tickets with work log for that tech )
Thanks
I m trying to build some MySQL queries around the incident requests could you please assist :
1- a query that can be ran weekly and get the sum of the tech time elapsed for all the tickets worked ( weekly total for the last 4 weeks )
2- top five ticket for specific techs that contain the highest total amount of work log time for the last 6 days
3 - top 5 categories and number of tickets for each cat for last 6 days
4 - total amount of ticket worked the previous week (all tickets with work log for that tech )
Thanks