Query library
Sample data

Net sales trend

Example 3 of 5 · ShopifyQL sample dashboard

All queries
sales
TIMESERIES
SINCE
Get on Shopify

See whether the business is compounding or cooling before the week closes.

ShopifyQL

Easy query

From sales, show net sales by day for the last 30 days.

FROM sales
SHOW net_sales
TIMESERIES day
WITH CURRENCY 'USD'
SINCE startOfDay(-30d)
UNTIL today
ORDER BY day ASC
VISUALIZE net_sales TYPE line

Period net sales

$214k

+8.2%

Best day

Aug 1

$12.1k

Avg daily net

$7.1k

+6%

vs prior 30d

+$16.2k

+8.2%

Trend

Sample store · last 30 days

Results

Sample data as if returned from Shopify Analytics

DayNet salesOrders
Jul 25$10,40088
Jul 27$9,90083
Jul 29$11,30095
Jul 31$11,00092
Aug 1$12,100101