Report not found

There was a problem finding this report.
Reverse Pivot Example
May 2, 2014 · Refreshed 1 day ago

Collaborators

Run History
SELECT years.*, earthquakes.magnitude, CASE year WHEN 2000 THEN year_2000 WHEN 2001 THEN year_2001 WHEN 2002 THEN year_2002 WHEN 2003 THEN year_2003 WHEN 2004 THEN year_2004 WHEN 2005 THEN year_2005 WHEN 2006 THEN year_2006 WHEN 2007 THEN year_2007 WHEN 2008 THEN year_2008 WHEN 2009 THEN year_2009 WHEN 2010 THEN year_2010 WHEN 2011 THEN year_2011 WHEN 2012 THEN year_2012 ELSE NULL END AS number_of_earthquakes FROM tutorial.worldwide_earthquakes earthquakes CROSS JOIN ( SELECT year FROM (VALUES (2000),(2001),(2002),(2003),(2004),(2005),(2006), (2007),(2008),(2009),(2010),(2011),(2012)) v(year) ) years
SELECT years.*, earthquakes.magnitude, CASE year WHEN 2000 THEN year_2000 WHEN 2001 THEN year_2001 WHEN 2002 THEN year_2002 WHEN 2003 THEN year_2003 WHEN 2004 THEN year_2004 WHEN 2005 THEN year_2005 WHEN 2006 THEN year_2006 WHEN 2007 THEN year_2007 WHEN 2008 THEN year_2008 WHEN 2009 THEN year_2009 WHEN 2010 THEN year_2010 WHEN 2011 THEN year_2011 WHEN 2012 THEN year_2012 ELSE NULL END AS number_of_earthquakes FROM tutorial.worldwide_earthquakes earthquakes CROSS JOIN ( SELECT year FROM (VALUES (2000),(2001),(2002),(2003),(2004),(2005),(2006), (2007),(2008),(2009),(2010),(2011),(2012)) v(year) ) years
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-table id="table_990439be488d" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ 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