Cannot find the field I like to subtract in Configure function field in Reports

jamietayam
Kilo Explorer

I'm trying to subtract two dates, but Incident opened is not showing in Add Fields.

Table: SLA Breakdown by Assignment 
Fields to be subtracted:

Task.Opened - this is Incident Opened date and time

Start - this is the start date and time of the Task SLA.

 

jamietayam_0-1769131063488.png

sys-created_on is the Date and Time of the Creation of the Task. What I need is for Task.Opened but dot is not allowed.

jamietayam_1-1769131157888.png

 

Is there a workaround? We need this in our report to get transfer duration from opening the ticket to sending it to a specific resolver group.

 

 

0 REPLIES 0