Panel refresh in dashboard

[mskccvb]

If a panel in dashboard refresh every 1 hour, and want to show what time refreshed in the text area [ like "As of 4pm", "As of 5pm" etc.]. Any idea of how to implement it?

[kamlesh_vaghela]

@mskccvb 

Try below example.

<dashboard>
  <label>Panel Refresh</label>
  <row>
    <panel>
      <title>Refresh Panel Test</title>
      <table>
        <title>Refresh Panel at $tk_refresh_at$</title>
        <search>
          <query>index=_internal | stats count by sourcetype 
| eval refresh_at = strftime(now(),"%H %p")</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
          <done>
            <set token="tk_refresh_at">$result.refresh_at$</set>
          </done>
        </search>
        <fields>sourcetype,count</fields>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
  </row>
</dashboard>

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

Thanks
Kamlesh Vaghela