Hi.
I generated an XML export of All tickets, users etc. from the Freshdesk account, but there’s no resolved-at or closed-at field. How can I calculate it? I may assume that the updated-at is the closed/resolved date, but I doubt it is always the case as there’re some updates that can happen to the ticket even if it was closed a long time ago.
Does anyone have any advice on how to get those? This is a basic metric that is available via API, but how to extract it from XML file?
Thanks!
Question
How to calculate resolved/closed date from XML export?
+6Hi
Good day to you. It can be captured via Automation API webhook on a text field and then can be extracted in the XML report
- Create Two text Fields - Resolved At and Closed At
- In Ticket Update Automation, Trigger is Status is Updated from Any to Resolved
then trigger webhook, to update the Resolved At text field with the placeholder {{ticket.modified_on}} (more available here). Below SNIP FYR -
Repeat the same procedure for Closed At text field to fill the Modified date value on Status update from Any to Closed.
Hope this helps.
Vinoth | Freshdesk product expert | Are you interested in learning more about how our services can help add value to your business? Check out our Professional Services - https://www.freshworks.com/professional-services/ to know more & get started.
+1HI may i suggest an easier way? Why not send all the data on Google Sheets and filter from there?
Just curious if you have tried this.
If you want any help in this process, happy to help
Reply
Join the Community
Already have an account? Login.
Sign in to the Community
No account yet? Create an account.
Social Login
Login with LinkedInor use your username
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.