Report not found

There was a problem finding this report.

Report

2006 Oscar Nominees

2006 Top Roles

Example - Datasets JSON Object Structure
July 12, 2018 · Refreshed 11 months ago
Description
This report contains two sample queries and allows you to visually explore how these query results are exposed via the JavaScript datasets JSON array. Query results are added to the datasets[] array in the order that they are created in the report.

Collaborators

Run History
SELECT nominee, category, movie FROM tutorial.oscar_nominees WHERE year = 2006 and winner = true
SELECT nominee, category, movie FROM tutorial.oscar_nominees WHERE year = 2006 and winner = true
SELECT * FROM tutorial.nominee_filmography WHERE year = 2006 AND rating <= 3
SELECT * FROM tutorial.nominee_filmography WHERE year = 2006 AND rating <= 3
<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-text id="text_5992bc4a-19d3-4930-b065-a8ca4ac8d50b" dataset="dataset" options="text_options"> <p>TIP: You can easily explore datasets[] for your own report in the <a href="https://webmasters.stackexchange.com/questions/8525/how-do-i-open-the-javascript-console-in-different-browsers" target="_blank">JavaScript console in your browser</a>. To do this:</p> <p><br></p> <p>1) Add the following code snippet to your report using the <a href="https://help.modeanalytics.com/articles/reports/#html-editor" target="_blank">HTML editor</a>:</p> <pre class="ql-syntax" spellcheck="false">&lt;script&gt; console.log('Explore datasets below this line:'); console.log(datasets); &lt;/script&gt; </pre> <p><br></p> <p>2) Open the <a href="https://webmasters.stackexchange.com/questions/8525/how-do-i-open-the-javascript-console-in-different-browsers" target="_blank">JavaScript console</a> in your browser and look for the words "Explore datasets below this line". Click on the next entry in the console to explore that report's datasets[] object.</p> </mode-text> </div> </div> <div class="row"> <div class="col-md-12"> <mode-text id="text_ed7ce770-e02a-4823-a3eb-1e3e64e920ac" dataset="dataset" options="text_options"> <h2><strong>Example 1</strong></h2> </mode-text> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_47419005a7c0" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-text id="text_623472eb-d725-4bb3-f14e-cb40646f4660" dataset="dataset" options="text_options"> <p>The following JSON object is available by referencing datasets[0] in JavaScript in the HTML editor (use ⊕ and ⊖ to explore):</p> </mode-text> </div> </div> <div class="row" data-row-height="medium"> <div class="col-md-12"> <div id="json-1"></div> </div> </div> <div class="row"> <div class="col-md-12"> <mode-text id="text_bfd9ba3a-5e39-41ee-fe89-37825f5ba53d" dataset="dataset" options="text_options"> <h2><strong>Example 2</strong></h2> </mode-text> </div> </div> <div class="row" data-row-height="medium"> <div class="col-md-12"> <mode-table id="table_af049d44afaf" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-text id="text_859ed2df-089f-45fc-9093-b1976f089c31" dataset="dataset" options="text_options"> <p>The following JSON object is available by referencing datasets[1] in JavaScript in the HTML editor (use ⊕ and ⊖ to explore):</p> </mode-text> </div> </div> <div class="row" data-row-height="medium"> <div class="col-md-12"> <div id="json-2"></div> </div> </div> <div class="row"> <div class="col-md-12"> <mode-text id="text_0a9cf470-8cb5-4f5f-a823-a3ea5e1433e7" dataset="dataset" options="text_options"> <p><a href="https://github.com/caldwell/renderjson" target="_blank"><em>RenderJSON</em></a><em> (interactive JSON explorer used in this report) - Copyright © 2013-2017 David Caldwel. Permission to use, copy, modify, and/or distribute this software for any purpose with or without fee is hereby granted, provided that the above copyright notice and this permission notice appear in all copies.</em></p> </mode-text> </div> </div> </div> <script type="text/javascript" src="https://caldwell.github.io/renderjson/renderjson.js"></script> <script> document.getElementById("json-1").appendChild(renderjson.set_show_to_level(1)(datasets[0])); document.getElementById("json-2").appendChild(renderjson.set_show_to_level(1)(datasets[1])); </script> <script> console.clear() console.log("You can explore the datasets[] object just below this line"); console.log("----------------------------------------------------------") console.log(datasets); </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