There is a more recent run of this report. Click here to view it.

Report not found

There was a problem finding this report.

Report

Carrier

Carrier monthly

Overall

Overall weekly

Dashboard - Shippo
April 21, 2017 · Refreshed over 2 years ago
Cloned from Shippo Dashboard

Collaborators

Run History
SELECT month, tracking_company, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM ( SELECT f.id AS id, f.order_id, DATE_TRUNC('year',f.created_at) AS year, DATE_TRUNC('month',f.created_at) AS month, DATE_TRUNC('week',f.created_at) AS week, DATE_TRUNC('day',f.created_at) AS day, tracking_company, s.price, CASE WHEN shipment_status = 'failure' THEN 1 ELSE 0 END AS failure FROM demo.orders__fulfillments f JOIN demo.shopify_orders_shipping s ON f.order_id = s.order_id ) AS shipments WHERE day BETWEEN '2015-12-28' AND '2016-12-31' GROUP BY 1,2 ORDER BY 1,2
SELECT month, tracking_company, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM {{ @shipments }} WHERE day BETWEEN '2015-12-28' AND '2016-12-31' GROUP BY 1,2 ORDER BY 1,2
SELECT tracking_company, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM ( SELECT f.id AS id, f.order_id, DATE_TRUNC('year',f.created_at) AS year, DATE_TRUNC('month',f.created_at) AS month, DATE_TRUNC('week',f.created_at) AS week, DATE_TRUNC('day',f.created_at) AS day, tracking_company, s.price, CASE WHEN shipment_status = 'failure' THEN 1 ELSE 0 END AS failure FROM demo.orders__fulfillments f JOIN demo.shopify_orders_shipping s ON f.order_id = s.order_id ) AS shipments WHERE day BETWEEN '2015-12-28' AND '2017-01-01' GROUP BY 1 ORDER BY 1
SELECT tracking_company, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM {{ @shipments }} WHERE day BETWEEN '2015-12-28' AND '2017-01-01' GROUP BY 1 ORDER BY 1
SELECT COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM ( SELECT f.id AS id, f.order_id, DATE_TRUNC('year',f.created_at) AS year, DATE_TRUNC('month',f.created_at) AS month, DATE_TRUNC('week',f.created_at) AS week, DATE_TRUNC('day',f.created_at) AS day, tracking_company, s.price, CASE WHEN shipment_status = 'failure' THEN 1 ELSE 0 END AS failure FROM demo.orders__fulfillments f JOIN demo.shopify_orders_shipping s ON f.order_id = s.order_id ) AS shipments WHERE day BETWEEN '2015-12-28' AND '2017-01-01'
SELECT COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM {{ @shipments }} WHERE day BETWEEN '2015-12-28' AND '2017-01-01'
SELECT week, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM ( SELECT f.id AS id, f.order_id, DATE_TRUNC('year',f.created_at) AS year, DATE_TRUNC('month',f.created_at) AS month, DATE_TRUNC('week',f.created_at) AS week, DATE_TRUNC('day',f.created_at) AS day, tracking_company, s.price, CASE WHEN shipment_status = 'failure' THEN 1 ELSE 0 END AS failure FROM demo.orders__fulfillments f JOIN demo.shopify_orders_shipping s ON f.order_id = s.order_id ) AS shipments WHERE day BETWEEN '2015-12-28' AND '2017-01-01' GROUP BY 1 ORDER BY 1
SELECT week, COUNT(id) AS shipments, AVG(price) AS avg_price, SUM(failure) AS failures, SUM(failure) / COUNT(id)::NUMERIC AS failure_rate FROM {{ @shipments }} WHERE day BETWEEN '2015-12-28' AND '2017-01-01' GROUP BY 1 ORDER BY 1
<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_ac0143008f66" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-8"> <mode-chart id="chart_51b893309590" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-4"> <mode-chart id="chart_cc6d07067036" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row" data-row-height="small"> <div class="col-md-12"> <mode-chart id="chart_caf8d301ab83" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-4"> <mode-chart id="chart_36d2a1a88b1a" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-8"> <mode-chart id="chart_9d9f916e7e06" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row" data-row-height="small"> <div class="col-md-12"> <mode-chart id="chart_31cedac06a0a" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-4"> <mode-chart id="chart_296ca10e6e11" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-8"> <mode-chart id="chart_6cc71e5eae0a" 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