Discrepancy in Duration Field Display between List View, Report View, and Excel Export

yana7
Tera Contributor

‎08-28-2024 01:19 AM

I am encountering an inconsistency in how a Duration field is displayed across List View, Report View, and Excel exports. The field in question is "Response Time New," which is of type "Duration."

Here's the breakdown of the issue:

  • List View: The field correctly displays only the duration value (e.g., "5 minutes").

  • Report View: The report view, as shown in the attached image, displays the duration value along with a date/time component resembling "1970........".

  • Excel Export: When exported to Excel, the field contains a numerical value representing the duration in seconds (e.g., 300 for 5 minutes).

How can I configure the report view to display the "Response Time New" field consistently with the list view, showing only the duration value and omitting the date/time component?

Table List View

yana7_1-1724832845517.png

 

 

Report View 

yana7_0-1724832777260.png

 

0 Helpfuls
  • 264 Views
1 REPLY 1

Mark Manders
Mega Patron

‎08-28-2024 04:20 AM

Can you try creating it as Platform Analytics report? I just tried that on my instance and it shows the expected 'minutes/seconds' instead of the javascript addition of 1970.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls