Report for a count of Updated Tickets

Monica Burgess
Kilo Contributor

I know I can get an overall updated count but the requirements are tricky. Since this is a billable report, meaning this is for our vendor who get paid differently based on tickets opened, updated, and resolved. I am able to get opened and resolved counts but I am having trouble with updated. The vendor will update tickets multiple times and I only want to get a count for one time. Tasks can be even trickier because if they update the request, the requested item, and a task associated it should only count as one. 

1 ACCEPTED SOLUTION

nayanawadhiya1
Kilo Sage

Hello,

There is a field on the Task table called Updates which will give you a count of the number of updates on an Incident, Problem, or Change record; I would add it to the list view and not the form view.

View solution in original post

3 REPLIES 3

nayanawadhiya1
Kilo Sage

Hello,

There is a field on the Task table called Updates which will give you a count of the number of updates on an Incident, Problem, or Change record; I would add it to the list view and not the form view.

Tracy Davis
Giga Guru

can you do a count on where the 'Updated' field is not null?  This field just records the date of the last update so you may just be able to get a simple count by using this field.

nayanawadhiya1
Kilo Sage

Any update on this?
Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.