There is a more recent run of this report. Click here to view the most recent run of this report.

Report not found

There was a problem finding this report.
Distribution of Lego piece count by decade
July 13, 2016 · Refreshed about 2 years 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.

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