Report not found

There was a problem finding this report.

Report

Accounts table

Orders table

Sales reps table

Sales reps who didn't close deals

Sales reps not selling
September 22, 2016 · Refreshed almost 3 years ago

Collaborators

Run History
SELECT * FROM demo.sales_reps
SELECT * FROM demo.sales_reps
SELECT * FROM demo.orders
SELECT * FROM demo.orders
SELECT * FROM demo.accounts
SELECT * FROM demo.accounts
SELECT sr.id AS sales_rep_id, sr.name AS sales_rep_name, sr.region_id AS sales_rep_region_id FROM demo.sales_reps sr LEFT JOIN( SELECT o.id AS order_id, sr.id as sales_rep_id FROM demo.orders o JOIN demo.accounts a ON o.account_id = a.id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id WHERE o.occurred_at BETWEEN '2016-09-05' AND '2016-09-15 23:59:59' ) a ON sr.id = a.sales_rep_id WHERE a.order_id is NULL
SELECT sr.id AS sales_rep_id, sr.name AS sales_rep_name, sr.region_id AS sales_rep_region_id FROM demo.sales_reps sr LEFT JOIN( SELECT o.id AS order_id, sr.id as sales_rep_id FROM demo.orders o JOIN demo.accounts a ON o.account_id = a.id JOIN demo.sales_reps sr ON sr.id = a.sales_rep_id WHERE o.occurred_at BETWEEN '2016-09-05' AND '2016-09-15 23:59:59' ) a ON sr.id = a.sales_rep_id WHERE a.order_id is NULL
<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-table id="table_219cc6539120" 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