topic Re: Display date/Time range in report in Dashboards & Visualizations

Display date/Time range in report

DonDandrea — Mon, 20 Oct 2014 13:01:35 GMT

I have created a form with a time selector dropdown box. When I print the results the dropdown box does not display. I need to have the dates and times selected displayed on the report. How can I do that? This is also useful for other dropdown boxes that are not time selectors.

<input type="time" searchWhenChanged="true">
  <default>Last 7 days</default>
</input>

Thank you,
Don

Re: Display date/Time range in report

DonDandrea — Mon, 20 Oct 2014 13:39:47 GMT

I have made it a little further. AI am using a simple HTML tag to display text. Now I need to figure out how to convert -7d and Now into meaningful values to display.

Report Date From: $earliest$To: $latest$

Any help you could provide would still be appreciated.

Thank you,
Don

Re: Display date/Time range in report

DonDandrea — Mon, 20 Oct 2014 13:53:25 GMT

  <table>
    <searchString>|gentimes start=-1 | addinfo | convert ctime(info_m*) | eval Timerange=info_min_time." to ".info_max_time | table Timerange</searchString>
    <earliestTime>$earliest$</earliestTime>
    <latestTime>$latest$</latestTime>
  </table>