topic Re: Is there a function to turn a time range into human-readable string? in Dashboards & Visualizations

Is there a function to turn a time range into human-readable string?

unitedmarsupial — Fri, 13 Dec 2019 19:38:10 GMT

I've created a dashboard with a shared "time-input" (named range) -- all of the panels refer to it:

      <earliest>$range.earliest$</earliest>
      <latest>$range.latest$</latest>

I'd like each panel's title to reflect the currently-picked range -- showing it in human-readable form like "Last 4 hours" or "Yesterday from 2am to 3am". Is this possible?

Update: Ok, I found I can add something like this to the titles:

... between $range.earliest$ and $range.latest$

and it will be translated to, for example between -7d@h and now. Maybe, there are better alternatives?..

Re: Is there a function to turn a time range into human-readable string?

richgalloway — Fri, 13 Dec 2019 20:27:34 GMT

Check out the reltime function.

Re: Is there a function to turn a time range into human-readable string?

to4kawa — Fri, 13 Dec 2019 22:37:54 GMT

| makeresults 
| addinfo 
| eval _time=info_max_time 
| reltime 
| rename reltime as last_time 
| eval _time=info_min_time 
| reltime 
| rename reltime as first_time
| eval output_text="Search period: between ".first_time." to ".last_time

you can hide the panel and pass output_text in tokens.

Re: Is there a function to turn a time range into human-readable string?

vnravikumar — Fri, 13 Dec 2019 23:19:20 GMT

Check this

<input type="time" searchWhenChanged="true">
        <label>Enter the time range</label>
        <default>
          <earliest>-1d@d</earliest>
          <latest>@d</latest>
        </default>
        <change>
          <set token="displayTime">($label$)</set>
        </change>
      </input>

Re: Is there a function to turn a time range into human-readable string?

to4kawa — Fri, 13 Dec 2019 23:42:40 GMT

It is enough to use in the Last something.
If Today is specified, it is regrettable that it will be Custom time.