UQL how to only get latest value by date

[deltamelter]

I have a json data set with dozens of values updated (mostly) daily. every day's data is kept for 30days.
so if I want to know the current values I have to somehow filter by date and then keep the name and the latest price for each name. Maybe the other values for that name too, but really only intereseted in price right now.
Thought I could use UQL to summarize by date, but that doesn't give me an option to get just the single latest price, eg

parse-json
| summarize "date"=max("date") by "name"
| project "price", "name"
| extend "price"=tonumber("price")

Also considered order by and limit, but there are new "name" units added all the time so it is not possible to say how may to limit.

Really I just want to be able to look up the latest price value for a given name, but such filtering doesn't seem part of the datasource plugin.. ??

do I miss something? any hints? it there another way? I thought UQL would be most flexible.

I will attach the data set sample with just 4 such item types and 2 dates for each....
sample.txt

[
    {
        "date": "2022-02-19",
        "name": "Chia",
        "price": "73.09352567",
        "volumeUsd": "6673435.21",
        "marketcap": 232291225
    },
    {
        "date": "2022-02-19",
        "name": "Spacebucks",
        "price": "0.00033132",
        "volumeUsd": "11.60",
        "marketcap": 662640
    },
    {
        "date": "2022-02-19",
        "name": "Skynet",
        "price": "0.00099721",
        "volumeUsd": "0.04",
        "marketcap": 2770
    },
    {
        "date": "2022-02-20",
        "name": "Chia",
        "price": "75.30489199",
        "volumeUsd": "17429875.72",
        "marketcap": 240015065
    },
    {
        "date": "2022-02-20",
        "name": "Spacebucks",
        "price": "0.00040157",
        "volumeUsd": "1.30",
        "marketcap": 803140
    },
    {
        "date": "2022-02-20",
        "name": "STAI",
        "price": "0.04665859",
        "volumeUsd": "166.63",
        "marketcap": 158138
    },
    {
        "date": "2022-02-21",
        "name": "Chia",
        "price": "75.230489199",
        "volumeUsd": "17429875.72",
        "marketcap": 240015065
    },
    {
        "date": "2022-02-21",
        "name": "Spacebucks",
        "price": "0.000240157",
        "volumeUsd": "1.30",
        "marketcap": 803140
    },
    {
        "date": "2022-02-21",
        "name": "STAI",
        "price": "0.024665859",
        "volumeUsd": "166.63",
        "marketcap": 158138
    }
]

[yesoreyeram]

with order by "" desc and limit 1 you should be able to get what you want. Can you post the sample dataset?
If you don't want "name" in your results, you can use project-away "name" to remove that column from results.

[deltamelter]

But still doesn't work. Only installing thru the grafana plugin catalog works, but that is only 8.0

[yesoreyeram]

how your are installing the plugin? The demo grafana instance of the plugin installs from zip file. So it should work

[deltamelter]

docker run with
-e "GF_INSTALL_PLUGINS=https://github.com/yesoreyeram/grafana-infinity-datasource/releases/download/v0.8.3/yesoreyeram-infinity-datasource-0.8.3.zip;yesoreyeram-infinity-datasource" using grafana/grafana:latest

[deltamelter]

I'll just wait until you publish to the grafana catalog...

[deltamelter]

I don't know what is going on with this plugin, it says it is upgraded to 0.83, but UQL just does not work beyond parse-json

is there some additional dependency for UQL?