Report not found

There was a problem finding this report.
Lego set summary
July 5, 2016 · Refreshed about 1 year ago

Collaborators

Run History
SELECT *, CASE WHEN year IN ('1950','1953','1954','1955','1956','1957','1958','1960','1961','1962','1966','1971','1973','1988') THEN 'White was the main color' WHEN year IN ('1959','1963','1967','1968','1969','1970','1974','1975','1977','1978','1985') THEN 'Red was the main color' WHEN year ='1964' THEN 'Blue was the main color' WHEN year IN ('1979','1981','1987') THEN 'Light gray was the main color' WHEN year ='1965' THEN 'Red and white were the main colors' WHEN year ='1984' THEN 'Black and blue were the main colors' WHEN year ='1982' THEN 'Light gray and black were the main colors' ELSE 'Black was the main color' END as main FROM( SELECT year::varchar as year, white, red, blue, black, light_gray, (white + red + blue + black + light_gray)as total FROM modeanalytics.new_colors_for_lego_chart )as a
SELECT *, CASE WHEN year IN ('1950','1953','1954','1955','1956','1957','1958','1960','1961','1962','1966','1971','1973','1988') THEN 'White was the main color' WHEN year IN ('1959','1963','1967','1968','1969','1970','1974','1975','1977','1978','1985') THEN 'Red was the main color' WHEN year ='1964' THEN 'Blue was the main color' WHEN year IN ('1979','1981','1987') THEN 'Light gray was the main color' WHEN year ='1965' THEN 'Red and white were the main colors' WHEN year ='1984' THEN 'Black and blue were the main colors' WHEN year ='1982' THEN 'Light gray and black were the main colors' ELSE 'Black was the main color' END as main FROM( SELECT year::varchar as year, white, red, blue, black, light_gray, (white + red + blue + black + light_gray)as total FROM modeanalytics.new_colors_for_lego_chart )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; } </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_c9bbb7599c89" options="python_options"></mode-python> </div> </div> </div> <script> $("#python_c9bbb7599c89 .chart-content").css("height",650) $("#python_c9bbb7599c89 .mode-python").css("height",650) $("#python_c9bbb7599c89 .mode-python").css("max-height",650) $("#python_c9bbb7599c89 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