Hello,
I am really struggling with the query builder.
I would like to build a query that is as follows:
--
I am really struggling with the query builder.
I would like to build a query that is as follows:
- Works for a specific queue i.i. Queue = 'queuename'
- Applies to all activity in the queue since the 1st of the CURRENT calendar month
- Outputs the total timeworked for the queue in that period.
So, I should get output that says something like
queue = queuename
timeworked (for all tickets, totalled) since 1st of current month = xx minutes
I will then make a saved search and use a dashboard notification to send that around.
Is what i am asking even possible?
Many thanks,
Alex
--
Alex Rhys-Hurn | ITworX Limited
P.O. Box 1649, 00502, Karen, Kenya
Tel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541
Web: www.itworx.co.ke
P.O. Box 1649, 00502, Karen, Kenya
Tel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541
Web: www.itworx.co.ke
