Recent searches


No recent searches

Thomas Koch's Avatar

Thomas Koch

Joined Apr 24, 2023

·

Last activity Apr 26, 2023

Following

0

Followers

0

Total activity

4

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Thomas Koch

Thomas Koch commented,

Community comment Q&A - Reporting and analytics

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,

Community comment Q&A - Reporting and analytics

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,

Post Q&A - Reporting and analytics

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