Skip to main content
Question

Report on Time Spent in Status


Forum|alt.badge.img+3

Hi all- hoping someone can help me set up a report that I want to schedule out to my agents. Can I configure a report to return all tickets that have been in a certain status (or any of 3 statuses) for a certain period of time? For instance, I want to schedule a report to email the assigned agent a list of tickets that have been “waiting on customer” for 5 or more days at the time the report runs. I know I could set up a notification using time triggers, but I feel like the individual emails are more likely to be overlooked and would like to provide a more concise list once a week or so. I appreciate any help!

Did this topic help you find an answer to your question?

3 replies

eeha0120
Skilled Expert
Forum|alt.badge.img+12
  • Skilled Expert
  • 732 replies
  • November 2, 2023

Hi.

I like the way you think.

 

I invite you to submit this possible filters as a Feature Request and share the link in order we could vote. I’d definitely vote for this.

 

Sadly as it sounds, adding a filter by the time a ticket has been in certain status is (currently) not possible.

 

You could create such report, but without specifying how long the ticket has been is such status.

This reporte could be like this:

 

With the following setup for this widget:

 

Then, set your required fields in Underlying data:

 

Then, you can schedule from the widget itself (not on the report level) in order to have access to Underlying data options:

 

You could schedule it to be weekly and use either option containing CSV of tabular data.

 

In this example I made for you, I created a simple report with all Agents, but as per your suggestion, you would need to create different widgets, one per each agent, filtered by a specific agent in a particular widget, and create an schedule for every widget with the Email Recipient of each agent.

 

Hope this helps.

I’m actually taking your idea and I will deploy it for my team.

 

Thanks for this inquiry/suggestion.

 


Regards,


VishnuV-Loop
Community Debut
Forum|alt.badge.img+1
  • Community Debut
  • 1 reply
  • March 18, 2024

Hi

My organization also has a requirement to filter by the time a ticket was spent on a status. Any update when this request would be rolled out?

 

 - Vishnu


eeha0120
Skilled Expert
Forum|alt.badge.img+12
  • Skilled Expert
  • 732 replies
  • March 18, 2024

Hi.

I’m not sure if the Request was created in Freshworks Ideas | Freshworks Community

If not, I invite you to create it.

That way, you could track the status of it.

 

 

Regards,


Reply