Hey team, struggling to wrap my head around writing a query to correctly aggregate over space and time.
In this example I am looking at an inventory metric (a point in time metric), and so I the time aggregation needs to be
last. You can see me doing this using aggregateWindow to aggregate my data over time with fn=last. However, as soon as I want to use a
last no longer makes sense. I want it to aggregate
last over time for each series, and then group using a
sum over space. How can I do a
sum but an aggregateWindow
last ? I’ve attached a screenshot of the my data. Setting group="", should result in a single line of 65.