Alex Zimmer

Hello, 

I am trying to determine the duration during which a text field was NULL. I have tried both of the following formulas as attributes and as metrics on the “Updates History” dataset, and no combination has returned anything. Text field name is “Jira ID”.

IF ([Changes - Field name]="Jira ID")
AND ([Changes - Previous value] = "NULL") AND ([Changes - New value] != "NULL")
THEN VALUE(Field changes time (min))
ENDIF

IF ([Changes - Field name]="Jira ID" )
AND ([Changes - Previous value] = “NULL”)
THEN VALUE(Field changes time (min))
ENDIF

Can anyone advise? Thank you in advance.

Alex