Recent searches
No recent searches

Thomas Koch
Joined Apr 24, 2023
·
Last activity Apr 26, 2023
Following
0
Followers
0
Total activity
4
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Thomas Koch
Thomas Koch commented,
SOLVED!
Hi Christopher - thank you so much for this - it seems to have done the trick! Perfect!
Cheers,
Tom
View comment · Edited Apr 26, 2023 · Thomas Koch
0
Followers
0
Votes
0
Comments
Thomas Koch commented,
Hi Christopher,
oh good point - my quieres should use 'Ticket updated - Date' - and that should be >7 days and then only look for tickets that are not "!=", solved or closed.
I tried
COUNT(FILTER([Ticket ID], DATE_DIFF(TODAY(), [Ticket updated - Date] - Date]) > 7 AND [Ticket status - Status] != "Closed" AND [Ticket status - Status] != "Solved"))
unfortunately I get the same message - :(
Cheers,
Tom
View comment · Posted Apr 25, 2023 · Thomas Koch
0
Followers
0
Votes
0
Comments
Thomas Koch created a post,
I'm trying to create a calculated metric for a report that will show me % of tickets that haven't been updated in 7 days.
I've tried a few queries
COUNT(FILTER([Ticket ID], DATE_DIFF(TODAY(), [Ticket solved - Date]) > 7 AND [Ticket status - Status] != "Closed" AND [Ticket status - Status] != "Solved"))
and this
COUNT(IF (DATE_DIFF(TODAY(), [Ticket solved - Date]) > 7 AND [Ticket status - Status] != "Closed" AND [Ticket status - Status] != "Solved", [Ticket ID], NULL))
and this
IF (DATE_DIFF(TODAY(), [Ticket solved - Date]) > 7 AND [Ticket status - Status] != "Closed" AND [Ticket status - Status] != "Solved") THEN 1 ELSE 0 ENDIF
Call it something like 'not-updated-tickets'
I was then going to create another metric Tickets - [Ticket ID]
and finally Result Calculation Metric
(not-updated-ticket / COUNT(Tickets)) * 100
But I keep getting a syntax error already on the first SQL - if anyone has a working example of the report I'm looking for - I'd be happy if you could share.
Thanks,
T
Posted Apr 24, 2023 · Thomas Koch
0
Followers
3
Votes
5
Comments