Report not found

There was a problem finding this report.
Westworld Character Mentions Matrix
November 4, 2016 · Refreshed over 2 years ago

Collaborators

Run History
SELECT 'Abernathy' AS source, 'Abernathy' AS target, -5 AS edge_size UNION ALL SELECT sc.name AS source, mc.name AS target, COUNT(m.id) AS edge_size FROM modeanalytics.westworld_mentions m JOIN modeanalytics.westworld_characters sc ON m.speaking_character_id = sc.id AND sc.is_major_character is TRUE JOIN modeanalytics.westworld_characters mc ON m.mentioned_character_id = mc.id AND mc.is_major_character is TRUE GROUP BY 1,2 ORDER BY 1,2
SELECT 'Abernathy' AS source, 'Abernathy' AS target, -5 AS edge_size UNION ALL SELECT sc.name AS source, mc.name AS target, COUNT(m.id) AS edge_size FROM modeanalytics.westworld_mentions m JOIN modeanalytics.westworld_characters sc ON m.speaking_character_id = sc.id AND sc.is_major_character is TRUE JOIN modeanalytics.westworld_characters mc ON m.mentioned_character_id = mc.id AND mc.is_major_character is TRUE GROUP BY 1,2 ORDER BY 1,2
WITH nodes AS( SELECT c.id, c.name AS node, CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'AI' END AS node_group, COUNT(l.id) AS node_size 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,3 ), speaking_characters AS( SELECT DISTINCT m.speaking_character_id, COUNT(m.id) FROM modeanalytics.westworld_mentions m GROUP BY 1 ), mentioned_characters AS( SELECT DISTINCT m.mentioned_character_id, COUNT(m.id) FROM modeanalytics.westworld_mentions m GROUP BY 1 HAVING COUNT(m.id) > 1 ) SELECT nodes.node, nodes.node_group, nodes.node_size FROM nodes LEFT JOIN speaking_characters ON nodes.id = speaking_characters.speaking_character_id LEFT JOIN mentioned_characters ON nodes.id = mentioned_characters.mentioned_character_id WHERE (nodes.id IN (speaking_characters.speaking_character_id) OR nodes.id IN (mentioned_characters.mentioned_character_id)) ORDER BY 3 DESC
WITH nodes AS( SELECT c.id, c.name AS node, CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'AI' END AS node_group, COUNT(l.id) AS node_size 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,3 ), speaking_characters AS( SELECT DISTINCT m.speaking_character_id, COUNT(m.id) FROM modeanalytics.westworld_mentions m GROUP BY 1 ), mentioned_characters AS( SELECT DISTINCT m.mentioned_character_id, COUNT(m.id) FROM modeanalytics.westworld_mentions m GROUP BY 1 HAVING COUNT(m.id) > 1 ) SELECT nodes.node, nodes.node_group, nodes.node_size FROM nodes LEFT JOIN speaking_characters ON nodes.id = speaking_characters.speaking_character_id LEFT JOIN mentioned_characters ON nodes.id = mentioned_characters.mentioned_character_id WHERE (nodes.id IN (speaking_characters.speaking_character_id) OR nodes.id IN (mentioned_characters.mentioned_character_id)) ORDER BY 3 DESC
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/d3-tip/0.6.7/d3-tip.min.js"></script> <style> body { background: #fcfcfc !important; } .chart { background-color: #fcfcfc; border: none; } .mode-embed .mode-object { border: none; background: #fcfcfc; } .js-table-container { background-color: #fcfcfc; } </style> <div id="network-matrix"></div> <script> alamode.networkMatrix( { "node_query": "Query 2", "edge_query": "Query 1", "html_element": "#network-matrix", "title": " ", "chart_width": 485, "chart_height": 485, "padding_for_names": 118, "left_label": "Speaker", "top_label": "Mentioned Character", "group_colors": { "Human": "#5685c4", "AI": "#be4705" } } ) </script> <img src="https://dl.dropboxusercontent.com/s/v3mdiz700kbi8ee/Screen%20Shot%202016-11-10%20at%201.29.31%20PM.png" alt="Legend" style=" margin-left: 23%;">
{{ 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