Ask A Guru: What are the formules for 'Sales over time' Report entities like Shipping and Refund?

New Member
11 0 0

We have explored 'Analytics' tab on Shopify Store for 'Sales over time' report and there are columns for which we need formules applied by Shopify to calculate these vaules.
We have tried to tally our downloaded 'Shipping' and 'Refunds' data with Analytics tab but it is not matching.
Can you please let us know formules and also the date ranges meaning in terms of Shipping and Refund on 'Sales over time' report.

Example: Shipping = Amount of shipping cost for orders placed in specific date range or Amount of shipping cost for orders which are shipped in specific date range.