Recent searches


No recent searches

Alex Zimmer's Avatar

Alex Zimmer

Joined Oct 09, 2023

·

Last activity Oct 16, 2024

Following

0

Followers

0

Total activity

3

Votes

0

Subscriptions

2

ACTIVITY OVERVIEW

Latest activity by Alex Zimmer

Alex Zimmer commented,

CommentExplore recipes

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

View comment · Posted Oct 16, 2024 · Alex Zimmer

0

Followers

0

Votes

0

Comments