JSONPath Error: Unable to Parse Token max()

Grafana Installation
#1

I want to get the maximum value from the given data but max() function shows error my data is as under

{
    "Items": [
        {
            "queueName": "basic",
            "totalNumberOfCalls": 100,
            "longestCall": 10,
            "queueSLA": 50
        },
        {
            "queueName": "inBound-inq",
            "totalNumberOfCalls": 120,
            "longestCall": 11,
            "queueSLA": 60
        },
        {
            "queueName": "support-inq",
            "totalNumberOfCalls": 200,
            "longestCall": 15,
            "queueSLA": 65
        },
        {
            "queueName": "verification-inq",
            "totalNumberOfCalls": 80,
            "longestCall": 13,
            "queueSLA": 70
        },
        {
            "queueName": "booking-inq",
            "totalNumberOfCalls": 105,
            "longestCall": 14,
            "queueSLA": 75
        }
    ]
}

I am using query max($…longestCall)
Please help me to solve this

#2

would be nice to know which plugin you are using. And what do you want the final result to look like, which data points?

#3

I am Using JSON API as data source plugin. and i want to get the queueName with longest call in queue and Queue name with minimum SLA value

1 Like
#4

method #1 using jsonata (pretty sure even with jsonata there is a better way to do it)

image
image969×813 80.5 KB

1 Like
#5

method #2 (lots of tranformation)

image
image1142×758 81.6 KB

image
image930×771 40.1 KB

#6

@yosiasz one more question can we make Sub penals inside a penal. I searched about that everyone said that it is not supported by grafana
Thank you

#7

maybe stats is better

image
image1084×381 15.6 KB

1 Like
#8

might want to post another question on that and not hijack this one?

#9

Sure Thanks @yosiasz you are very helpful and Kind Person Thanks again

1 Like
#11

image
image1004×711 56.5 KB

@yosiasz please have a look

#12

Very good now would be a good time for you to fish as you have been shown how to fish :wink:

Go to this link and time to learn some jsonata

https://try.jsonata.org/FXUzKcStN

Paste the data coming from your Walkboard Demo. We have no idea what the data from that json api looks like

Here is the documentation for jsonata.

#13

I am already reading about JSONata. Thanks for the help you are really a great person