I'm trying to re-create the 'Sales over Time' report from the Shopify front end, but I can't seem to recreate it properly through the data in the API. There seems to be a lot of complexities causing 'total sales' to not be correct.
For example, querying the Order API, if two transactions take place in the same order, they both get returned as the same same 'Order'. However, the transactions API doesn't seem to give me what I need either. Would really appreciate some support on this!