Recent searches


No recent searches

Katie Barton's Avatar

Katie Barton

Joined Oct 16, 2021

·

Last activity Oct 16, 2021

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

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