Merge Rows with the same value in one row

  • What Grafana version and what operating system are you using? - v7.5.4

  • What are you trying to achieve? -Hello, I am new to Grafana and I have a promql query that basically returns the number free disk space of a kubernetes Nodes. The promql query returns the results, however its returns in time series. I wanted to merge same value(in my case instance) to be just unique in one row.

  • How are you trying to achieve it?
    I am using Transform >> Outer join and then merge and but it is not working.

Promql that I used:

100 - (100 * ((node_filesystem_avail_bytes{mountpoint="/",fstype!="rootfs"} )  / (node_filesystem_size_bytes{mountpoint="/",fstype!="rootfs"}) ))

Please attached screenshot.

Thanks in advance!

Hi @scrappedprince

Have you tried using a panel like the Stat panel, and then choosing to display a paricular calculation using the standard field options:

You might want to try the last value. That should reduce each series to a single value. Does this help?