생성할 필터 세트
-
Zendesk Tickets
테이블status != deleted
-
Filter set name
:Tickets we count
-
Filter set logic
:
계산된 열
생성할 열
-
Zendesk user's
테이블-
User is agent? (Yes/No)
-
-
Column type
-Same Table > Calculation
-
Input columns
-role
,email
-
SQL Calculation
- case when
Ais not
nulland
A!=end-user
thenYes
whenB
이(가)null
이(가) 아닌 경우B
like%@magento.com
thenYes
elseNo
end -
@magento.com
을(를) 도메인으로 바꾸기 -
Datatype
-String
-
-
-
Zendesk audits_~_events
테이블-
정의 선택:
Joined Column
-
Create Path:
-
Many:
Zendesk audits_~_events.author_id8
-
One:
Zendesk users.id
-
table 선택:
Zendesk users
-
column 선택:
User is agent? (Yes/No)
-
Path:
Zendesk audits_~_events.author_id = Zendesk users.id
-
-
Author is agent? (Yes/No)
-
Zendesk audits
테이블-
정의 선택:
Exists
-
Create Path:
-
Many:
Zendesk audits_~_events._id_of_parent
-
One:
Zendesk audits._id
-
table 선택:
Zendesk audits_~_events
-
Path:
Zendesk audits_~_events._id_of_parent = Zendesk audits._id
-
Filter:
-
field_name
=status
-
type
=Change
-
value
=solved
-
정의 선택:
Exists
-
table 선택:
Zendesk audits_~_events
-
Path:
Zendesk audits_~_events._id_of_parent = Zendesk audits._id
-
Filter:
Author is agent? (Yes/No)
-
type
=Comment
-
public
=1
-
-
Status changes to solved? (1/0)
-
Is agent comment? (1/0)
-
Zendesk Tickets
테이블-
정의 선택:
Joined Column
-
Create Path:
-
Many:
Zendesk tickets.requester_id
-
One:
Zendesk users.id
-
table 선택:
Zendesk users
-
column 선택:
email
-
Path:
Zendesk tickets.requester_id = Zendesk users.id
-
정의 선택:
Joined Column
-
table 선택:
Zendesk users
-
column 선택:
role
-
Path:
Zendesk tickets.requester_id = Zendesk users.id
-
정의 선택:
Max
-
Create Path:
-
Many:
Zendesk audits.ticket_id
-
One:
Zendesk tickets.id
-
table 선택:
Zendesk audits
-
column 선택:
created_at
-
Path:
Zendesk audits.ticket_id = Zendesk tickets.id
-
Filter:
-
status
이(가)solved = 1
(으)로 변경됨 -
정의 선택:
Min
-
table 선택:
Zendesk audits
-
column 선택:
created_at
-
Path:
Zendesk audits.ticket_id = Zendesk tickets.id
-
Filter:
-
Is agent comment? = 1
-
-
Requester's email
-
Requester's role
-
Ticket's latest solved date
-
First agent response date
-
Seconds to resolution
-
-
Column type
-Same Table > Date Difference
-
Ticket's latest solved date
-created_at
-
-
-
Seconds to first response
-
-
Column type
-Same Table > Date Difference
-
First agent response date
-created_at
-
-
-
Requester's ticket number
-
-
Column type
-Same Table > Event Number
-
Event Owner
-requester_id
-
Event Rank
-created_at
-
-
-
Ticket created_at (hour of day)
-
-
Column type
- "같은 테이블 > 계산" -
Input columns
-created_at
-
SQL Calculation
-to_char(A,'HH24')::int
-
Datatype
- 정수
-
-
-
Ticket created_at (day of week)
-
-
Column type
- "같은 테이블 > 계산" -
Input columns
-created_at
-
Calculation
-to_char(A,'D')||'. '||to_char(A,'Day')
*
Datatype
-String
-
-
-
customer_entity
테이블-
정의 선택:
Count
-
Create Path:
-
Many:
Zendesk tickets.email
-
One:
customer_entity.email
-
table 선택:
Zendesk tickets
-
Path:
Zendesk tickets.email = customer_entity.email
-
Filter:
-
Tickets we count
-
-
User's lifetime number of support tickets requested
-
Has user filed a support ticket? (Yes/No)
-
-
Column type
- "같은 테이블 > 계산" -
Input columns
-User's lifetime number of support tickets requested
-
Calculation
-case when A>0 then 'Yes' else 'No' end
-
Datatype
-String
-
-
-
Zendesk Tickets
테이블- 정의 선택:
Joined Column
- table 선택:
customer_entity
- column 선택:
User's lifetime number of support tickets requested
- Path:
Zendesk tickets.email = customer_entity.email
- 정의 선택:
-
Requester's lifetime number of support tickets
지표
-
새 티켓 Zendesk개
Tickets we count
-
Zendesk tickets
테이블에서 -
이 지표는 Count 을 수행합니다.
-
id
열에서 -
created_at
타임스탬프로 정렬됨 -
Filter:
-
해결된 티켓 Zendesk개
Tickets we count
closed, solved
의 상태
-
Zendesk tickets
테이블에서 -
이 지표는 Count 을 수행합니다.
-
id
열에서 -
created_at
타임스탬프로 정렬됨 -
Filter:
-
Zendesk명의 고유 사용자가 티켓을 정리함
Tickets we count
-
Zendesk tickets
테이블에서 -
이 지표는 고유 개수 를 수행합니다.
-
requester_id
열에서 -
created_at
타임스탬프로 정렬됨 -
Filter:
-
Zendesk평균/중간 티켓 확인 시간
Tickets we count
closed, solved
의 상태
-
Zendesk tickets
테이블에서 -
이 지표는 평균(또는 중간값) 을 수행합니다.
-
Seconds to resolution
열에서 -
created_at
타임스탬프로 정렬됨 -
Filter:
-
Zendesk첫 번째 응답까지의 평균/중간 시간
- 카운트되는 티켓
- 상태 IN 닫힘, 해결됨
-
Zendesk tickets
테이블에서 -
이 지표는 평균(또는 중간값) 을 수행합니다.
-
Seconds to first response
열에서 -
created_at
타임스탬프로 정렬됨 -
Filter: