Hi everyone,
I am trying to build a dashboard in Platform Analytics to filter Requested Items (RITM) that took between 1 and 2 days to close. However, I am facing an issue where the duration fields are empty or zero, preventing me from filtering the data.
I need create a simple indicator/report for RITMs where the duration is between 1-2 days. But for all my closed RITMs, the OOB field calendar_duration shows "0 Seconds". The business_duration field is also empty.
What I have tried so far:
Visual Validation: In the List View, I can see dates populated in both the Opened and Closed columns. The State is "Closed Complete" (Active = false).
Dictionary Check: I verified the dictionary entries for opened_at and closed_at. Both exist and are type glide_date_time.
Function Field Attempt: I tried to create a new Function Field in the dictionary to calculate the value on the fly without using scripts.
Definition: glide_function:datediff(opened_at, closed_at)
Result: It still returns "0 Seconds" for all rows.
Alternative Function Field: I suspected closed_at might be null in the backend, so I tried creating a Function Field using glide_function:datediff(opened_at, sys_updated_on). This also resulted in "0 Seconds" or did not calculate as expected.
