Report not found

There was a problem finding this report.
Lego piece count percentile by decade
July 13, 2016 · Refreshed about 1 month ago

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_640f20d51e1f" options="python_options"></mode-python> </div> </div> </div> <script> $("#python_640f20d51e1f .chart-content").css("height",640) $("#python_640f20d51e1f .mode-python").css("height",640) $("#python_640f20d51e1f .mode-python").css("max-height",640) $("#python_640f20d51e1f img").css("max-height",640) </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