From the docs, this query will give you the last year of sales separated by month (which will also show the month to date sales):
FROM orders
VISUALIZE sum(net_sales)
TYPE line
GROUP BY month ALL
SINCE -1y
UNTIL today
From the docs, this query will give you the last year of sales separated by month (which will also show the month to date sales):
FROM orders
VISUALIZE sum(net_sales)
TYPE line
GROUP BY month ALL
SINCE -1y
UNTIL today