Best way to show TopN of value

Grafana Time Series Panel
1

Hi,

I’m trying to find the best panel to show Top N of a metric.
So far I only get decent result with Table Panel, which is operative, but nothing fancy…

Is there a way to show TopN value in a PieChart Panel or Graph Panel?

what I’ve tried so far → Piechart

image
image928×709 43.2 KB

But in influxDB, the query is OK, it returns 3 values…

SELECT top(“max”,host_name,3) FROM(SELECT max(“value”) FROM “metric_memory_usage” WHERE time >= now() - 7d GROUP BY “host_name”)
name: metric_memory_usage
time top host_name

1561612600000000000 1099724640 wocudevel
1561973768000000000 85970408 wocu-demos
1561973777000000000 85970504 bgp-re

With Graph Panel I get this:

image
image1474×712 41.7 KB

But If i want to limit TOP N…

To be continued…
(will upload another image in next message)

1 Like
2

(…following my previous msg)

image
image1463×715 41.3 KB

It shows all values together like in Piechart panel.

:frowning:

Thanks in advanced.

1 Like
3

Hi! @exit2escritical did you find a way of doing it without the table panel? I have the same “problem”

1 Like