zendesk/ticket_submissions.dashboard.lookml at dev-jenna-kertz-jtcy · pipeline-looker-blocks/zendesk · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
- dashboard: ticket_submissions
  title: Ticket Submissions
  layout: grid
  rows:
    - elements: [all_tickets, orgs_submitting, avg_tickets_per_org]
      height: 150
    - elements: [tickets_submitted_by_org]
      height: 600
    - elements: [ticket_stats_by_org]
      height: 400
    - elements: [peak_hours, peak_days]
      height: 400

  filters:

  - name: date
    type: date_filter
  - name: organization
    type: string_filter


  elements:

  - name: all_tickets
    type: single_value
    model: zendesk
    explore: tickets
    measures: [tickets.count]
    sorts: [tickets.count desc]
    limit: 500
    show_single_value_title: true
    single_value_title: All time tickets submitted
    show_comparison: false
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name

  - name: orgs_submitting
    type: single_value
    model: zendesk
    explore: tickets
    measures: [tickets.count_orgs_submitting]
    sorts: [tickets.count_orgs_submitting desc]
    limit: 500
    show_single_value_title: true
    single_value_title: Organizations submitting tickets
    show_comparison: false
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name

  - name: avg_tickets_per_org
    title: Average tickets per org
    type: single_value
    model: zendesk
    explore: tickets
    measures: [tickets.count_distinct_organizations, tickets.count]
    dynamic_fields:
    - table_calculation: average_tickets_per_org
      label: Average tickets per org
      expression: round(${tickets.count} / ${tickets.count_distinct_organizations}, 2)
    hidden_fields: [tickets.count_distinct_organizations, tickets.count]
    sorts: [tickets.count_distinct_organizations desc]
    limit: 500
    show_comparison: false
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name

  - name: ticket_stats_by_org
    title: Ticket stats by organization
    type: table
    model: zendesk
    explore: ticket_metrics
    dimensions: [organizations.name]
    measures: [tickets.count_open_tickets,
      tickets.count_solved_tickets, tickets.count, ticket_metrics.avg_full_resolution_time_in_days__business]
    sorts: [tickets.count_new_tickets desc]
    limit: 500
    listen:
      date: ticket_metrics.created_date
      organization: ticket_metrics.organization_name

  - name: tickets_submitted_by_org
    title: Ticket submitted by organization
    type: looker_line
    model: zendesk
    explore: tickets
    dimensions: [tickets.created_at_month, tickets.organization_name]
    pivots: [tickets.organization_name]
    measures: [tickets.count]
    sorts: [tickets.count desc, tickets.organization_name]
    limit: 1000
    column_limit: 5000
    stacking: ''
    colors: ['#FFCC00', '#1E2023', '#3399CC', '#CC3399', '#66CC66', '#999999', '#FF4E00', '#A2ECBA', '#9932CC', '#0000CD']
    show_value_labels: false
    label_density: 25
    legend_position: center
    x_axis_gridlines: false
    y_axis_gridlines: true
    show_view_names: true
    limit_displayed_rows: false
    y_axis_combined: true
    show_y_axis_labels: true
    show_y_axis_ticks: true
    y_axis_tick_density: default
    show_x_axis_label: true
    show_x_axis_ticks: true
    x_axis_scale: time
    y_axis_scale_mode: linear
    show_null_points: true
    point_style: none
    interpolation: linear
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name


  - name: peak_hours
    title: Peak hours
    type: looker_column
    model: zendesk
    explore: tickets
    dimensions: [tickets.time_hour_of_day]
    measures: [tickets.count]
    sorts: [tickets.time_hour_of_day]
    limit: 500
    column_limit: 50
    stacking: percent
    show_value_labels: false
    label_density: 25
    legend_position: center
    x_axis_gridlines: false
    y_axis_gridlines: true
    show_view_names: true
    limit_displayed_rows: false
    y_axis_combined: true
    show_y_axis_labels: true
    show_y_axis_ticks: true
    y_axis_tick_density: default
    show_x_axis_label: true
    show_x_axis_ticks: true
    x_axis_scale: auto
    ordering: none
    show_null_labels: false
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name

  - name: peak_days
    title: Peak days
    type: looker_column
    model: zendesk
    explore: tickets
    dimensions: [tickets.time_day_of_week]
    measures: [tickets.count]
    sorts: [tickets.time_day_of_week]
    limit: 500
    column_limit: 50
    stacking: percent
    show_value_labels: false
    label_density: 25
    legend_position: center
    x_axis_gridlines: false
    y_axis_gridlines: true
    show_view_names: true
    limit_displayed_rows: false
    y_axis_combined: true
    show_y_axis_labels: true
    show_y_axis_ticks: true
    y_axis_tick_density: default
    show_x_axis_label: true
    show_x_axis_ticks: true
    x_axis_scale: auto
    ordering: none
    show_null_labels: false
    listen:
      date: tickets.created_at_date
      organization: tickets.organization_name