Recent searches


No recent searches

Katie True's Avatar

Katie True

Joined May 16, 2021

·

Last activity Oct 16, 2021

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

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