Table with only latest items in time series

[ckozma]

I scrape a site for items, quantities, and prices as a project for the community, and chart the data using Grafana. One chart is giving me trouble, I need to keep only the latest item of each title. The way that the data is structured it seemed like this would be an easy query but it is not.

[ckozma]

just want to ideally grab the latest one from the sequence for each item

[ckozma]

and finally, here is the query that I think should work and doesn’t return any results for some reason!!!

[ckozma]

Solution posted below: