Report not found

There was a problem finding this report.
Customer Service Cube: By Issue Type
June 20, 2016 · Refreshed almost 4 years ago
Description
For more about using the customer service cube, check out this post: https://blog.modeanalytics.com/measure-customer-service-with-python/. Want to learn how to track customer service metrics with SQL? Read this: https://blog.modeanalytics.com/tracking-customer-service-metrics/

Collaborators

Run History
SELECT 'Signup' AS issue_type, '2016-04-04' AS day, 4 as avg_handle_time, 1.12 as avg_interactions, 8.2 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-05' as day, 5 as avg_handle_time, 1.14 as avg_interactions, 9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-06' AS day, 4 as avg_handle_time, 1.18 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-07' as day, 5 as avg_handle_time, 1.12 as avg_interactions, 8.1 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-08' AS day, 5 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-11' as day, 5 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-12' AS day, 6 as avg_handle_time, 1.16 as avg_interactions, 7.7 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-13' as day, 4 as avg_handle_time, 1.24 as avg_interactions, 6.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-14' AS day, 6 as avg_handle_time, 1.12 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-15' as day, 7 as avg_handle_time, 1.22 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-18' AS day, 5 as avg_handle_time, 1.20 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-19' as day, 8 as avg_handle_time, 1.12 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-20' AS day, 4 as avg_handle_time, 1.18 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-21' as day, 5 as avg_handle_time, 1.21 as avg_interactions, 9.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-04' AS day, 27 as avg_handle_time, 1.75 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-05' as day, 24 as avg_handle_time, 1.82 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-06' AS day, 23 as avg_handle_time, 1.75 as avg_interactions, 3.1 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-07' as day, 28 as avg_handle_time, 1.79 as avg_interactions, 3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-08' AS day, 26 as avg_handle_time, 1.9 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-11' as day, 25 as avg_handle_time, 1.8 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-12' AS day, 29 as avg_handle_time, 1.8 as avg_interactions, 3.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-13' as day, 26 as avg_handle_time, 1.4 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-14' AS day, 28 as avg_handle_time, 1.7 as avg_interactions, 4.5 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-15' as day, 25 as avg_handle_time, 1.82 as avg_interactions, 5.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-18' AS day, 24 as avg_handle_time, 1.60 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-19' as day, 27 as avg_handle_time, 1.72 as avg_interactions, 4.9 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-20' AS day, 27 as avg_handle_time, 1.68 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-21' as day, 28 as avg_handle_time, 1.32 as avg_interactions, 2.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-04' AS day, 29 as avg_handle_time, 1.9 as avg_interactions, 9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-05' as day, 28 as avg_handle_time, 1.9 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-06' AS day, 29 as avg_handle_time, 1.75 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-07' as day, 28 as avg_handle_time, 1.92 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-08' AS day, 28 as avg_handle_time, 1.78 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-11' as day, 25 as avg_handle_time, 1.82 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-12' AS day, 28 as avg_handle_time, 1.96 as avg_interactions, 8.7 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-13' as day, 29 as avg_handle_time, 1.84 as avg_interactions, 9.2 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-14' AS day, 28 as avg_handle_time, 1.71 as avg_interactions, 7.5 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-15' as day, 27 as avg_handle_time, 1.72 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-18' AS day, 28 as avg_handle_time, 1.80 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-19' as day, 24 as avg_handle_time, 1.82 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-20' AS day, 28 as avg_handle_time, 1.74 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-21' as day, 29 as avg_handle_time, 1.71 as avg_interactions, 8.3 as avg_quality ORDER BY 1,2 DESC
SELECT 'Signup' AS issue_type, '2016-04-04' AS day, 4 as avg_handle_time, 1.12 as avg_interactions, 8.2 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-05' as day, 5 as avg_handle_time, 1.14 as avg_interactions, 9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-06' AS day, 4 as avg_handle_time, 1.18 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-07' as day, 5 as avg_handle_time, 1.12 as avg_interactions, 8.1 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-08' AS day, 5 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-11' as day, 5 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-12' AS day, 6 as avg_handle_time, 1.16 as avg_interactions, 7.7 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-13' as day, 4 as avg_handle_time, 1.24 as avg_interactions, 6.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-14' AS day, 6 as avg_handle_time, 1.12 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-15' as day, 7 as avg_handle_time, 1.22 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-18' AS day, 5 as avg_handle_time, 1.20 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-19' as day, 8 as avg_handle_time, 1.12 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-20' AS day, 4 as avg_handle_time, 1.18 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Signup' AS representative, '2016-04-21' as day, 5 as avg_handle_time, 1.21 as avg_interactions, 9.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-04' AS day, 27 as avg_handle_time, 1.75 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-05' as day, 24 as avg_handle_time, 1.82 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-06' AS day, 23 as avg_handle_time, 1.75 as avg_interactions, 3.1 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-07' as day, 28 as avg_handle_time, 1.79 as avg_interactions, 3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-08' AS day, 26 as avg_handle_time, 1.9 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-11' as day, 25 as avg_handle_time, 1.8 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-12' AS day, 29 as avg_handle_time, 1.8 as avg_interactions, 3.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-13' as day, 26 as avg_handle_time, 1.4 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-14' AS day, 28 as avg_handle_time, 1.7 as avg_interactions, 4.5 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-15' as day, 25 as avg_handle_time, 1.82 as avg_interactions, 5.3 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-18' AS day, 24 as avg_handle_time, 1.60 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-19' as day, 27 as avg_handle_time, 1.72 as avg_interactions, 4.9 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-20' AS day, 27 as avg_handle_time, 1.68 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Tech' AS representative, '2016-04-21' as day, 28 as avg_handle_time, 1.32 as avg_interactions, 2.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-04' AS day, 29 as avg_handle_time, 1.9 as avg_interactions, 9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-05' as day, 28 as avg_handle_time, 1.9 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-06' AS day, 29 as avg_handle_time, 1.75 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-07' as day, 28 as avg_handle_time, 1.92 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-08' AS day, 28 as avg_handle_time, 1.78 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-11' as day, 25 as avg_handle_time, 1.82 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-12' AS day, 28 as avg_handle_time, 1.96 as avg_interactions, 8.7 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-13' as day, 29 as avg_handle_time, 1.84 as avg_interactions, 9.2 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-14' AS day, 28 as avg_handle_time, 1.71 as avg_interactions, 7.5 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-15' as day, 27 as avg_handle_time, 1.72 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-18' AS day, 28 as avg_handle_time, 1.80 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-19' as day, 24 as avg_handle_time, 1.82 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-20' AS day, 28 as avg_handle_time, 1.74 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Security' AS representative, '2016-04-21' as day, 29 as avg_handle_time, 1.71 as avg_interactions, 8.3 as avg_quality ORDER BY 1,2 DESC
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-python id="python_37b1ba166e50" options="python_options"></mode-python> </div> </div> </div> <script> $("mode-python .chart-content").css("height",700) $("mode-python .mode-python").css("height",700) $("mode-python .mode-python").css("max-height",700) $("mode-python img").css("max-height",700) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled