REPORT PARAMETERS

Report not found

There was a problem finding this report.
Parameter Types
April 19, 2018 · Refreshed about 17 hours ago

Collaborators

Run History
SELECT orders.occurred_at::DATE AS "Date", orders.id AS "Order ID", orders.standard_amt_usd AS "Standard", orders.gloss_amt_usd AS "Glossy", orders.poster_amt_usd AS "Poster" FROM demo.orders JOIN demo.accounts ON accounts.id=orders.account_id JOIN demo.sales_reps ON sales_reps.id=accounts.sales_rep_id JOIN demo.orders__fulfillments ON orders__fulfillments.order_id=orders.id JOIN demo.region on region.id=sales_reps.region_id WHERE orders.occurred_at >= '2016-01-12' AND orders.occurred_at <= '2016-12-21' AND region.name in ('Northeast') AND orders.total_amt_usd >= 0 AND orders.total_amt_usd <= 10000 AND orders__fulfillments.shipment_status = 'delivered' AND accounts.sales_rep_id in ('321500')
SELECT orders.occurred_at::DATE AS "Date", orders.id AS "Order ID", orders.standard_amt_usd AS "Standard", orders.gloss_amt_usd AS "Glossy", orders.poster_amt_usd AS "Poster" FROM demo.orders JOIN demo.accounts ON accounts.id=orders.account_id JOIN demo.sales_reps ON sales_reps.id=accounts.sales_rep_id JOIN demo.orders__fulfillments ON orders__fulfillments.order_id=orders.id JOIN demo.region on region.id=sales_reps.region_id WHERE orders.occurred_at >= '{{ order_start_date }}' AND orders.occurred_at <= '{{ order_end_date }}' AND region.name in ({{ sales_region }}) AND orders.total_amt_usd >= {{ order_min }} AND orders.total_amt_usd <= {{ order_max }} AND orders__fulfillments.shipment_status = '{{ shipment_status }}' AND accounts.sales_rep_id in ({{ sales_rep }}) {% form %} order_start_date: type: date default: 2016-01-01 description: Only display results for orders placed after this date order_end_date: type: date default: 2016-12-31 description: Only display results for orders placed before this date sales_region: type: multiselect default: [Northeast,West] description: Display results for one or more sales regions input_type: string options: [Northeast,Midwest,West,Southeast] order_min: type: text default: 0 label: Minimum Order Amt ($) description: Only display results for orders over this amount order_max: type: text default: 1000 label: Maximum Order Amt ($) description: Only display results for orders less than this amount shipment_status: type: select default: delivered options: [delivered,failure] {% endform %}
SELECT id, name FROM demo.sales_reps
SELECT id, name FROM demo.sales_reps {% form %} sales_rep: type: multiselect default: all options: labels: name values: id {% endform %}
<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-chart id="chart_df50465cdc3c" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_d71448cd01bd" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_065a25d8d747" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_d0cc2818877b" 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