This question was asked a few years ago by bhota, but it did not appear to be answered.
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 is imported as a whole number and shows a number like 58453000 which does not make any sense because the ticket the actual data is something like 16hrs 14mins
It imports as a whole number and when you try and change to a time it errors out
Best answer by Amrit Mishra
@joestract In data exports, the column/field ‘Resolution Time in Bhrs’ doesn’t display the time duration as a string/text but in a numeric format that should represent the number of hours taken to resolve the ticket. However, as you’ve rightly pointed out, currently the value is a very high number instead of the actual no. of hours taken for resolution. This is because, this column currently displays the time in milliseconds instead of hours. In your example, 58453000/3600000 will return the correct resolution time in business hours. However, I acknowledge this as an issue, will plan to get it fixed and share an update here.
@joestract In data exports, the column/field ‘Resolution Time in Bhrs’ doesn’t display the time duration as a string/text but in a numeric format that should represent the number of hours taken to resolve the ticket. However, as you’ve rightly pointed out, currently the value is a very high number instead of the actual no. of hours taken for resolution. This is because, this column currently displays the time in milliseconds instead of hours. In your example, 58453000/3600000 will return the correct resolution time in business hours. However, I acknowledge this as an issue, will plan to get it fixed and share an update here.
