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.
Lego sets
July 4, 2016 · Refreshed over 1 year ago

Collaborators

Run History
SELECT *, CASE WHEN descr ilike '%<br>%' THEN 'Sets:<br>-' ELSE 'Set: ' END as set FROM( SELECT year::varchar as year, pieces, string_agg("descr", '<br>-') AS descr FROM modeanalytics.lego_set WHERE pieces >3 GROUP BY 1,2)as a
SELECT *, CASE WHEN descr ilike '%<br>%' THEN 'Sets:<br>-' ELSE 'Set: ' END as set FROM( SELECT year::varchar as year, pieces, string_agg("descr", '<br>-') AS descr FROM modeanalytics.lego_set WHERE pieces >3 GROUP BY 1,2)as a
<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; } .modebar--hover { visibility: hidden; } </style> <script> $("#python_d91c2f6023d7 .chart-content").css("height", 650) $("#python_d91c2f6023d7 .mode-python").css("height", 650) $("#python_d91c2f6023d7 .mode-python").css("max-height", 650) $("#python_d91c2f6023d7 img").css("max-height", 650) </script> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-python id="python_d91c2f6023d7" options="python_options"></mode-python> </div> </div> </div>
{{ 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