Question

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

  • 28 July 2022
  • 1 reply
  • 371 views

Userlevel 3
Badge +4

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.


1 reply

Badge

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

Reply