Recent searches
No recent searches

Katie True
Joined May 16, 2021
·
Last activity Oct 16, 2021
Following
0
Followers
0
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Katie True
Katie True commented,
CommentWriting formulas
Hi, I'm trying to replicate the following Insights custom metric in Explore and can't seem to get the formula correct. Any advice?
Insights: SELECT AVG([Text Field] Duration in minutes)/60 WHERE Text Field = Group AND Ticket Status <> Deleted
I tried creating a standard calculation in the Tickets dataset, but only got this far (without getting the green checkmark)
Explore: SELECT([Changes - Field name]AVG(Field changes time (hrs))) WHERE [Changes - Field name] = [Update ticket group]
View comment · Posted Jan 11, 2021 · Katie True
0
Followers
0
Votes
0
Comments