Thibaut

Katerina Louka
Currently we can only add a tag to one query at a time, however I believe this is a great idea and if you want you can add your feedback here: Feedback - Reporting and analytics (Explore)
We keep a close eye on those threads to improve the product constantly!

Hi George Ntatianidis

I created a ticket for you so I can take a look directly at your issue. 
You will receive a notification about it soon. 

질문

Explore에서 후속 응답 대기 시간을 추적할 수 있나요? 

답변

아니요, 첫 번째 최종 사용자 응답과 그 다음 상담원 응답 사이의 지속 시간에 대해 보고할 수는 없습니다. 첫 번째 응답 시간과 달리 후속 응답 시간은 Explore의 메트릭에 명시적으로 캡처되지 않습니다.

자세한 내용은 Zendesk Support에 대한 메트릭 및 속성입니다.

Hi @...
Your company isn't in trouble :)

Indeed those results seems odd, I created a ticket for you in order to take a look directly at what went wrong. You should receive a notification about it soon. 

Hello,

This error would be due to Explore's limit being reached as explained here: Why do I receive a “Network error” in my query?

I would suggest you to reduce the date range of N1 and N2 in order to not go beyond the 50 000 rows, the limit can not be changed or modified so reducing the date range would be the best option.

Hi Dinara, 

In order to create this query you will first need to create a standard calculated attribute like this one: 

With this formula: 

IF INCLUDES_ALL([Ticket tags], "classical") THEN "Classical"
ELIF INCLUDES_ALL([Ticket tags], "electric") THEN "Electric"
ELIF INCLUDES_ALL([Ticket tags], "bass") THEN "Bass"
ENDIF

You will need to change the tags I used for the example with your own tags. 

Then you will need to create two date range calculated metrics like this one : 

Original metric: Tickets
Defined on: Ticket created

Then select the date range for N1, and reproduce the same for N2. 

Finally you will need to create two advanced fixed metrics like this: 

With this formula :

IF ([Ticket created - Date]>="2021-04-04"
AND [Ticket created - Date]<="2021-05-18")
THEN [Ticket ID]
ENDIF

You will need to change the dates to reflect N1 and on the second one, N2. 

Then you can finally place those new metrics and attribute in your query to have something like this: 

You can find here the related articles: 
- Getting started with custom metrics and attributes
- Adding time and date calculated metrics
- Adding fixed calculated metrics

Have a great day :)