Two Max Values in Table View

Grafana
1

With “SELECT max(“value”) FROM “W” WHERE (“friendly_name”::tag = ‘AIO PV2 (6x110Wh)’) AND $timeFilter” I get a Max Value back in a table panel. But is there a chance to get the two hightest Max Values in the table panel? I find no solution for it. thx, i’m very new in grafana.

2

It looks like this is not a Grafana question, but rather your datasource one.

Your query should be updated to something like this:

SELECT "value" FROM "W" WHERE ("friendly_name"::tag = 'AIO PV2 (6x110Wh)') AND $timeFilter
ORDER BY "value" DESC
LIMIT 2