AM using collectd to collect the metrics from the system, am using Influxdb as a database to collectd the metrics and Grafana for visualization. I need only the used RAM memory in percentage to display in grafana....
I need only the used memory value to show up in grafana exclusing the cached and buffered.
As of now i query grafana like
SELECT mean("value") *-1+100 FROM "memory_value" WHERE ("host" =~ /^$host$/ AND "type" = 'percent' AND "type_instance" = 'free') AND $timeFilter GROUP BY time($__interval),"host"
Which gives the wrong value.. Can anyone pls help me how to display the used RAM percentage