Single Value: Current Server RAM Usage

[mxanareckless]

I need a Single Value widget for a dashboard which displays current RAM usage in real-time.
This is what I have so far in SPL:

index=index host=host sourcetype=vmstat memUsedMB=*
| stats count

And this is all I'm getting:

How can I get something more like this? :

[manjunathmeti · Accepted solution]

hi @mxanareckless,
Check if this works for you.

<dashboard>
  <label>Memory Usage</label>
  <row>
    <panel>
      <single>
        <title>Memory</title>
        <search>
          <query>index=index host=host sourcetype=vmstat memUsedMB=*
| stats latest(memUsedMB) as memUsedMB
| eval totalMem=10000 , freeMemPerc=(100*(totalMem-memUsedMB))/totalMem</query>
          <earliest>rt-1m</earliest>
          <latest>rt</latest>
          <progress>
            <set token="perc">$result.freeMemPerc$</set>
          </progress>
        </search>
        <option name="refresh.display">progressbar</option>
        <option name="showSparkline">0</option>
        <option name="showTrendIndicator">0</option>
        <option name="underLabel">Free $perc$ %.</option>
      </single>
    </panel>
  </row>
</dashboard>

If this reply helps you, an upvote/like would be appreciated.

[renjith_nair]

Probably you should use

index=index host=host sourcetype=vmstat memUsedMB=*
| timechart max(memUsedMB) as memUsedMB