Recent searches
No recent searches

Katie Barton
Joined Oct 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 Barton
Katie Barton commented,
CommentWriting formulas
Hello,
Restating this question from 5 months ago. 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 Jun 10, 2021 · Katie Barton
0
Followers
0
Votes
0
Comments