Hi Rob, thank you for the advice! I have been spending some more time looking into this. Our Shopify schema has the following tables:abandoned_checkoutscollectscustom_collectionscustomersmetafieldsorder_refundsordersproductstransactionsThe one I need...

Yeah, I went through two different tables and tried various different date and aggregate fields, but none of them seemed to work. Shopify were not able to help, or provide details of the schema. I had to go through Singer.io who built the Stitch Shop...

Glad to hear it's not just me struggling here!

Hi all,I'm trying to replicate the Shopify 'Sales over time' report in our Snowflake instance. One component of that report calculates the total amount refunded to customers on that date, i.e. the refund date (not the order date). I have been struggl...