Report not found

There was a problem finding this report.

Report

Query 1

Query 2

Query 3

Query 4

Query 5

Query 6

Sample reports - KPI dashboard
August 11, 2016 · Refreshed 2 days ago

Collaborators

Run History
SELECT TO_CHAR(occurred_at,'YYYY')as year, COUNT(DISTINCT account_id) as customers FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, COUNT(DISTINCT account_id) as customers FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT r.name as region, SUM(o.total) / COUNT(sr.id) as units_sold_per_rep FROM demo.orders o JOIN demo.accounts a ON a.id = o.account_id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id JOIN demo.region r ON sr.region_id = r.id WHERE o.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 2 DESC
SELECT r.name as region, SUM(o.total) / COUNT(sr.id) as units_sold_per_rep FROM demo.orders o JOIN demo.accounts a ON a.id = o.account_id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id JOIN demo.region r ON sr.region_id = r.id WHERE o.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 2 DESC
SELECT r.name as region, SUM(o.total) FROM demo.orders o JOIN demo.accounts a ON a.id = o.account_id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id JOIN demo.region r ON sr.region_id = r.id WHERE o.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 2 DESC
SELECT r.name as region, SUM(o.total) FROM demo.orders o JOIN demo.accounts a ON a.id = o.account_id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id JOIN demo.region r ON sr.region_id = r.id WHERE o.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 2 DESC
SELECT TO_CHAR(occurred_at,'YYYY')as year, SUM(total) as reams_sold FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, SUM(total) as reams_sold FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, (SUM(total) - SUM(standard_qty)) / SUM(total) as non_standard_sales_perc FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, (SUM(total) - SUM(standard_qty)) / SUM(total) as non_standard_sales_perc FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, SUM(total_amt_usd) as rev FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
SELECT TO_CHAR(occurred_at,'YYYY')as year, SUM(total_amt_usd) as rev FROM demo.orders WHERE occurred_at BETWEEN '2015-01-01' AND '2016-12-31 23:59:59' GROUP BY 1 ORDER BY 1 ASC
<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-3"> <mode-chart id="chart_c3151f19f51d" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-3"> <mode-chart id="chart_12dcb8d364b4" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-3"> <mode-chart id="chart_85b72db205e5" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-3"> <mode-chart id="chart_db5917844ecf" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-6"> <mode-chart id="chart_b37939b85e4f" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-6"> <mode-chart id="chart_b8eec690c238" dataset="dataset" options="chart_options"></mode-chart> </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