Report not found

There was a problem finding this report.
Character Words Counts
November 4, 2016 · Refreshed over 2 years ago

Collaborators

Run History
WITH episodes AS( SELECT DISTINCT e.id, e.name, c.name AS character_name FROM modeanalytics.westworld_episodes e JOIN modeanalytics.westworld_lines l ON e.id = l.episode_id JOIN modeanalytics.westworld_characters c ON c.is_major_character is TRUE ), words AS( SELECT l.episode_id, c.name, SUM(l.word_count) AS words FROM modeanalytics.westworld_characters c LEFT JOIN modeanalytics.westworld_lines l ON c.id = l.character_id WHERE c.is_major_character is TRUE GROUP BY 1,2 ORDER BY 1,2 ) SELECT episodes.id, episodes.name, episodes.character_name, COALESCE(words.words,0) AS words, 'Words: ' || COALESCE(words.words,0) AS words_eng FROM episodes LEFT JOIN words ON episodes.id = words.episode_id AND episodes.character_name = words.name ORDER BY 1,3
WITH episodes AS( SELECT DISTINCT e.id, e.name, c.name AS character_name FROM modeanalytics.westworld_episodes e JOIN modeanalytics.westworld_lines l ON e.id = l.episode_id JOIN modeanalytics.westworld_characters c ON c.is_major_character is TRUE ), words AS( SELECT l.episode_id, c.name, SUM(l.word_count) AS words FROM modeanalytics.westworld_characters c LEFT JOIN modeanalytics.westworld_lines l ON c.id = l.character_id WHERE c.is_major_character is TRUE GROUP BY 1,2 ORDER BY 1,2 ) SELECT episodes.id, episodes.name, episodes.character_name, COALESCE(words.words,0) AS words, 'Words: ' || COALESCE(words.words,0) AS words_eng FROM episodes LEFT JOIN words ON episodes.id = words.episode_id AND episodes.character_name = words.name ORDER BY 1,3
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <style> body { background: #f0f0f0 !important; } .chart { background-color: #f0f0f0; border: none; } .mode-embed .mode-object { border: none; background: #f0f0f0; } .js-table-container { background-color: #f0f0f0; } </style> <div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-7"> <mode-python id="python_19614aeb7166" options="python_options"></mode-python> </div> <div class="col-md-5"></div> </div> </div> <script> alamode.resizeChartHeight({ chart: "python_19614aeb7166", height: 820 }) </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