Skip to main content
Question

Resolution Time in Bhrs in the Analytics Data Export shows big number


Forum|alt.badge.img+4
  • Skilled Expert
  • 15 replies

A data export is scheduled in the path Analytics > Settings > Data Export to export all Tickets through the API that is consumed by Power BI application. The field Resolution Time in Bhrs shows number like 58453000 which does not make any sense. Foe the same ticket the actual data is

Created Date - Dec 6, 2021 9:45 AM
Closed Date - Dec 10, 2021 7:36 AM
 Time taken - 16hrs 14mins

However in the report the Resolution Time in Bhrs is 58453000.

This field shows similar big number for all tickets.

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

2 replies

audministrator
Community Debut
Forum|alt.badge.img

You can calculate the resolution time in Power BI using DAX. 

I have a PBI template that just does that using native Power BI Queries.

No export needed, no limitations… has been used by many users before...

 

See here for more information :

PowerBI – Using FreshDesk Web Services API


Forum|alt.badge.img+3
  • Top Contributor
  • 4 replies
  • February 24, 2025

Did you ever find a solution to this that did not involve the above reply? I am experiencing the same issue and would love to figure it out.

 


Reply