Recent searches
No recent searches

Alex Zimmer
Joined Oct 09, 2023
·
Last activity Oct 16, 2024
Following
0
Followers
0
Total activity
3
Votes
0
Subscriptions
2
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Alex Zimmer
Alex Zimmer commented,
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