Skip to main content
Solved

Aged tickets

  • Apr 17, 2024 2:05 PM UTC
  • 17 replies
  • 917 views

Forum|alt.badge.img+1

Hi

I am struggling on how to create an “aged tickets” list for my dashboard. Would need to show all tickets in any status apart from resolved & closed that are under 90 days old. 

Any help welcome.

Best answer by Yusuf Ahmed

Hi @ian_k,

 

Thank you for your response. You can use the below widget/filter to get the tickets that are over 90 days old with all status except Resolved and Closed. I hope this helps!

 

Regards,

Yusuf Ahmed

View original

17 replies

Amrit Mishra
Contributor
Forum|alt.badge.img+8
  • Contributor
  • Apr 19, 2024 11:24 AM UTC

@ian_k please see the attached images on how to create such a widget in Analytics. The reports have a default filter of 90 days applied, so you don’t need to add this filter explicitly.

Widget showing tickets in statuses other than Closed and Resolved, grouped by ticket status

 

Filter option that excludes Closed and Resolved
 
Default filter of 90 days date range applied on the report

 


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Apr 19, 2024 12:29 PM UTC

Thanks but i messed up explaining the requirement. I need tickets OVER 90 days old.


Yusuf Ahmed
Community Debut
Forum|alt.badge.img+8
  • Community Debut
  • Answer
  • Apr 20, 2024 9:21 AM UTC

Hi @ian_k,

 

Thank you for your response. You can use the below widget/filter to get the tickets that are over 90 days old with all status except Resolved and Closed. I hope this helps!

 

Regards,

Yusuf Ahmed


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Apr 30, 2024 8:08 AM UTC

Hi

 

I’m confused - i can’t see a Metric “Tickets Created” nor metrics for “Time Period” or “Date Dimension”

 

Help!


Daniel Söderlund
Top Contributor ⭐
Forum|alt.badge.img+14

Thanks but i messed up explaining the requirement. I need tickets OVER 90 days old.

edit nvm  :) 


Daniel Söderlund
Top Contributor ⭐
Forum|alt.badge.img+14

Hi

 

I’m confused - i can’t see a Metric “Tickets Created” nor metrics for “Time Period” or “Date Dimension”

 

Help!

Share screenshots where you are looking. 


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Apr 30, 2024 8:20 AM UTC

Cloned a report to set this up but don’t see those metric options.


Daniel Söderlund
Top Contributor ⭐
Forum|alt.badge.img+14

Cloned a report to set this up but don’t see those metric options.

Click on the field “Enter and Select” and type in the filter value you need. 


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Apr 30, 2024 8:35 AM UTC

doesnt recognise

 

i can add date range dimension but not time period

 


Daniel Söderlund
Top Contributor ⭐
Forum|alt.badge.img+14

doesnt recognise

 

i can add date range dimension but not time period

 

Is this in a new report ?

The post is for Freshservice not Freshdesk. 

But time you need to use extra filter functions
 



 


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Apr 30, 2024 8:44 AM UTC

Freshservice, new report. Ideally i wanted to build this into a store card on my dashboard.


Gremlich
Apprentice
Forum|alt.badge.img
  • Apprentice
  • May 10, 2024 9:13 PM UTC

I am trying to do the same thing in Freshservice Analytics, but I also get no results when I try to use Ticket Age as a metric. What am I doing wrong?


Yusuf Ahmed
Community Debut
Forum|alt.badge.img+8
  • Community Debut
  • Jun 12, 2024 10:14 AM UTC

Hi @ian_k,

 

I am looping in @rajagopal.baladhandayutham to assit you with Freshservice query. @rajagopal.baladhandayutham could you please assist here. Thanks 

 

Regards,

Yusuf Ahmed


Forum|alt.badge.img+1
  • Contributor
  • Jun 14, 2024 11:21 AM UTC

Hello!

I would expect these to be standard metrics but you can create custom metrics within the analytics module. Navigate to Analytics > Settings > Custom Metrics. 

Here you can create your own metrics, however I am struggling to find the logic / expressions to calculate the ticket age. 


Forum|alt.badge.img+1
  • Contributor
  • Jun 14, 2024 11:51 AM UTC

Hello Again, 

 

just wanted to add that I think “Tickets” is the same as “Tickets Created” - Not sure on the Aged Tickets though. I have tried to create a custom attribute for aged tickets but I’ve not been able to get it to work yet. 


Forum|alt.badge.img+1
  • Author
  • Contributor
  • Jul 24, 2024 10:53 AM UTC

Can anyone at Fresh help with this ? I never heard from Rajagopal.


Forum|alt.badge.img
  • Apprentice
  • Nov 5, 2024 11:32 AM UTC

I am struggling with this also. When i create a new report, the metric ‘Ticket’ does not exist. Are there any articles on how to actually create the metric, and other metrics, at all, please?