Report not found

There was a problem finding this report.
Customer Service Cube: By Representative
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 'Jerry' AS representative, '2016-04-04' AS day, 22 as avg_handle_time, 1.32 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-05' as day, 20 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-06' AS day, 18 as avg_handle_time, 1.25 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-07' as day, 26 as avg_handle_time, 1.45 as avg_interactions, 9.1 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-08' AS day, 16 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.42 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-12' AS day, 21 as avg_handle_time, 1.16 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-13' as day, 20 as avg_handle_time, 1.24 as avg_interactions, 9.1 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-14' AS day, 23 as avg_handle_time, 1.32 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-15' as day, 19 as avg_handle_time, 1.22 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-18' AS day, 19 as avg_handle_time, 1.20 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-19' as day, 26 as avg_handle_time, 1.32 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-20' AS day, 19 as avg_handle_time, 1.18 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-21' as day, 22 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-04' AS day, 12 as avg_handle_time, 1.12 as avg_interactions, 5.2 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-05' as day, 9 as avg_handle_time, 1.12 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-06' AS day, 18 as avg_handle_time, 1.25 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-07' as day, 14 as avg_handle_time, 1.12 as avg_interactions, 5.1 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-08' AS day, 13 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-12' AS day, 8 as avg_handle_time, 1.16 as avg_interactions, 6.7 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-13' as day, 8 as avg_handle_time, 1.24 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-14' AS day, 6 as avg_handle_time, 1.12 as avg_interactions, 5.5 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-15' as day, 7 as avg_handle_time, 1.22 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-18' AS day, 12 as avg_handle_time, 1.20 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-19' as day, 11 as avg_handle_time, 1.32 as avg_interactions, 6.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-20' AS day, 10 as avg_handle_time, 1.18 as avg_interactions, 5.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-21' as day, 12 as avg_handle_time, 1.21 as avg_interactions, 4.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-04' AS day, 14 as avg_handle_time, 1.75 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-05' as day, 15 as avg_handle_time, 1.8 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-06' AS day, 13 as avg_handle_time, 1.75 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-07' as day, 18 as avg_handle_time, 1.79 as avg_interactions, 7 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-08' AS day, 14 as avg_handle_time, 1.9 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.8 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-12' AS day, 20 as avg_handle_time, 1.8 as avg_interactions, 7.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-13' as day, 12 as avg_handle_time, 1.4 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-14' AS day, 10 as avg_handle_time, 1.7 as avg_interactions, 4.5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-15' as day, 13 as avg_handle_time, 1.82 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-18' AS day, 14 as avg_handle_time, 1.60 as avg_interactions, 7.8 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-19' as day, 10 as avg_handle_time, 1.72 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-20' AS day, 11 as avg_handle_time, 1.68 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-21' as day, 20 as avg_handle_time, 1.32 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-04' AS day, 29 as avg_handle_time, 1.12 as avg_interactions, 5.2 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-05' as day, 28 as avg_handle_time, 1.62 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-06' AS day, 4 as avg_handle_time, 1.75 as avg_interactions, 1.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-07' as day, 5 as avg_handle_time, 1.92 as avg_interactions, 2.1 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-08' AS day, 23 as avg_handle_time, 1.34 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Kramer' 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 'Kramer' AS representative, '2016-04-12' AS day, 8 as avg_handle_time, 1.56 as avg_interactions, 3.7 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-13' as day, 29 as avg_handle_time, 1.63 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-14' AS day, 26 as avg_handle_time, 1.21 as avg_interactions, 9.5 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-15' as day, 17 as avg_handle_time, 1.52 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-18' AS day, 28 as avg_handle_time, 1.20 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-19' as day, 4 as avg_handle_time, 1.82 as avg_interactions, 1.9 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-20' AS day, 10 as avg_handle_time, 1.44 as avg_interactions, 5.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-21' as day, 9 as avg_handle_time, 1.31 as avg_interactions, 4.3 as avg_quality ORDER BY 1,2 DESC
SELECT 'Jerry' AS representative, '2016-04-04' AS day, 22 as avg_handle_time, 1.32 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-05' as day, 20 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-06' AS day, 18 as avg_handle_time, 1.25 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-07' as day, 26 as avg_handle_time, 1.45 as avg_interactions, 9.1 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-08' AS day, 16 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.42 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-12' AS day, 21 as avg_handle_time, 1.16 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-13' as day, 20 as avg_handle_time, 1.24 as avg_interactions, 9.1 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-14' AS day, 23 as avg_handle_time, 1.32 as avg_interactions, 8.5 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-15' as day, 19 as avg_handle_time, 1.22 as avg_interactions, 8.3 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-18' AS day, 19 as avg_handle_time, 1.20 as avg_interactions, 8.8 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-19' as day, 26 as avg_handle_time, 1.32 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-20' AS day, 19 as avg_handle_time, 1.18 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Jerry' AS representative, '2016-04-21' as day, 22 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-04' AS day, 12 as avg_handle_time, 1.12 as avg_interactions, 5.2 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-05' as day, 9 as avg_handle_time, 1.12 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-06' AS day, 18 as avg_handle_time, 1.25 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-07' as day, 14 as avg_handle_time, 1.12 as avg_interactions, 5.1 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-08' AS day, 13 as avg_handle_time, 1.14 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.22 as avg_interactions, 8.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-12' AS day, 8 as avg_handle_time, 1.16 as avg_interactions, 6.7 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-13' as day, 8 as avg_handle_time, 1.24 as avg_interactions, 4.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-14' AS day, 6 as avg_handle_time, 1.12 as avg_interactions, 5.5 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-15' as day, 7 as avg_handle_time, 1.22 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-18' AS day, 12 as avg_handle_time, 1.20 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-19' as day, 11 as avg_handle_time, 1.32 as avg_interactions, 6.9 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-20' AS day, 10 as avg_handle_time, 1.18 as avg_interactions, 5.4 as avg_quality UNION ALL SELECT 'Elaine' AS representative, '2016-04-21' as day, 12 as avg_handle_time, 1.21 as avg_interactions, 4.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-04' AS day, 14 as avg_handle_time, 1.75 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-05' as day, 15 as avg_handle_time, 1.8 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-06' AS day, 13 as avg_handle_time, 1.75 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-07' as day, 18 as avg_handle_time, 1.79 as avg_interactions, 7 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-08' AS day, 14 as avg_handle_time, 1.9 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-11' as day, 15 as avg_handle_time, 1.8 as avg_interactions, 5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-12' AS day, 20 as avg_handle_time, 1.8 as avg_interactions, 7.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-13' as day, 12 as avg_handle_time, 1.4 as avg_interactions, 4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-14' AS day, 10 as avg_handle_time, 1.7 as avg_interactions, 4.5 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-15' as day, 13 as avg_handle_time, 1.82 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-18' AS day, 14 as avg_handle_time, 1.60 as avg_interactions, 7.8 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-19' as day, 10 as avg_handle_time, 1.72 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-20' AS day, 11 as avg_handle_time, 1.68 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'George' AS representative, '2016-04-21' as day, 20 as avg_handle_time, 1.32 as avg_interactions, 7.9 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-04' AS day, 29 as avg_handle_time, 1.12 as avg_interactions, 5.2 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-05' as day, 28 as avg_handle_time, 1.62 as avg_interactions, 6 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-06' AS day, 4 as avg_handle_time, 1.75 as avg_interactions, 1.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-07' as day, 5 as avg_handle_time, 1.92 as avg_interactions, 2.1 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-08' AS day, 23 as avg_handle_time, 1.34 as avg_interactions, 7.4 as avg_quality UNION ALL SELECT 'Kramer' 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 'Kramer' AS representative, '2016-04-12' AS day, 8 as avg_handle_time, 1.56 as avg_interactions, 3.7 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-13' as day, 29 as avg_handle_time, 1.63 as avg_interactions, 8.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-14' AS day, 26 as avg_handle_time, 1.21 as avg_interactions, 9.5 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-15' as day, 17 as avg_handle_time, 1.52 as avg_interactions, 6.3 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-18' AS day, 28 as avg_handle_time, 1.20 as avg_interactions, 3.8 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-19' as day, 4 as avg_handle_time, 1.82 as avg_interactions, 1.9 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-20' AS day, 10 as avg_handle_time, 1.44 as avg_interactions, 5.4 as avg_quality UNION ALL SELECT 'Kramer' AS representative, '2016-04-21' as day, 9 as avg_handle_time, 1.31 as avg_interactions, 4.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_2a5213104df3" 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