Report not found

There was a problem finding this report.
Distribution of Lego piece count by decade
July 13, 2016 · Refreshed about 1 year ago
Cloned from Lego sets

Collaborators

Run History
SELECT CASE WHEN ls.year BETWEEN '1950' AND '1959' THEN '1950s' WHEN ls.year BETWEEN '1960' AND '1969' THEN '1960s' WHEN ls.year BETWEEN '1970' AND '1979' THEN '1970s' WHEN ls.year BETWEEN '1980' AND '1989' THEN '1980s' WHEN ls.year BETWEEN '1990' AND '1999' THEN '1990s' WHEN ls.year BETWEEN '2000' AND '2009' THEN '2000s' WHEN ls.year BETWEEN '2010' AND '2019' THEN '2010s' END as decade, pieces FROM modeanalytics.lego_set ls WHERE pieces >3 ORDER BY 1,2
SELECT CASE WHEN ls.year BETWEEN '1950' AND '1959' THEN '1950s' WHEN ls.year BETWEEN '1960' AND '1969' THEN '1960s' WHEN ls.year BETWEEN '1970' AND '1979' THEN '1970s' WHEN ls.year BETWEEN '1980' AND '1989' THEN '1980s' WHEN ls.year BETWEEN '1990' AND '1999' THEN '1990s' WHEN ls.year BETWEEN '2000' AND '2009' THEN '2000s' WHEN ls.year BETWEEN '2010' AND '2019' THEN '2010s' END as decade, pieces FROM modeanalytics.lego_set ls WHERE pieces >3 ORDER BY 1,2
<style> body { background: #cfd3d3 !important; } .chart { background-color: #cfd3d3; border: none; } .mode-embed .mode-object { border: none; background: #cfd3d3; } .js-table-container { background-color: #cfd3d3; } </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-12"> <mode-python id="python_dbda185d30b2" options="python_options"></mode-python> </div> </div> </div> <script> $("#python_dbda185d30b2 .chart-content").css("height",650) $("#python_dbda185d30b2 .mode-python").css("height",650) $("#python_dbda185d30b2 .mode-python").css("max-height",650) $("#python_dbda185d30b2 img").css("max-height",650) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query. Get help here.

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