topic Re: How to populate one time picker based on the selection of another time picker? in Dashboards & Visualizations

How to populate one time picker based on the selection of another time picker?

mnj1809 — Thu, 02 Jun 2022 21:52:00 GMT

Hello,

I've a requirement to populate the "Time2" time picker to be updated automatically based on the selection of "Time1" time picker. The "Time2" time picker should be = Time1- 1 day. for example, if I choose Today in Time1 then Time2 should be automatically populated as "Last 1 day". If I choose Yesterday in Time1 then Time2 should be automatically populated as "Last 2 days" (starting from 12:00 AM day before yesterday till end of yesterday.)

@bowesmana

Re: How to populate one time picker based on the selection of another time picker?

ITWhisperer — Fri, 03 Jun 2022 09:19:48 GMT

If you need a second pair of earliest and latest tokens, why not create this in the change handler of timer1?

Re: How to populate one time picker based on the selection of another time picker?

mnj1809 — Fri, 03 Jun 2022 09:44:32 GMT

How can I achieve that using change handler of timer1? Please share the code so that I can understand.

@ITWhisperer

Re: How to populate one time picker based on the selection of another time picker?

ITWhisperer — Fri, 03 Jun 2022 10:03:51 GMT

Try something like this

<input type="time" token="timepicker" searchWhenChanged="true"> <label></label> <default> <earliest>-24h@h</earliest> <latest>now</latest> </default> <change> <condition> <eval token="earliestdaybefore">relative_time(relative_time(now(),$timepicker.earliest$),"-1d")</eval> <eval token="latestdaybefore">relative_time(relative_time(now(),$timepicker.latest$),"-1d")</eval> </condition> </change> </input>

Re: How to populate one time picker based on the selection of another time picker?

mnj1809 — Fri, 03 Jun 2022 12:24:41 GMT

Thanks mate. It helped me.

@ITWhisperer

Re: How to populate one time picker based on the selection of another time picker?

mnj1809 — Sun, 05 Jun 2022 11:16:07 GMT

Hello,

I tried to set a default time on page load but I am getting below error:

Dashboard XML:

<form>
<label>Display Time Picker</label>
<init>
<set token="earliestdaybefore">-1d@d</set>
<set token="latestdaybefore">@d</set>
</init>
<fieldset submitButton="false">
<input type="time" token="time" searchWhenChanged="true">
<label>HVA Timeframe</label>
<default>
<earliest>@d</earliest>
<latest>now</latest>
</default>
<change>
<condition>
<eval token="earliestdaybefore">relative_time(relative_time(now(),$time.earliest$),"-1d")</eval>
<eval token="latestdaybefore">relative_time(relative_time(now(),$time.latest$),"-1d")</eval>
</condition>
</change>
</input>
</fieldset>
<row>
<panel>
<title>Previous Dates</title>
<table>
<search>
<query>| makeresults
| eval earliestdaybefore= $earliestdaybefore$,
latestdaybefore=$latestdaybefore$
| eval earliest_time=strftime(earliestdaybefore,"%Y-%m-%dT%H:%M:%S"),
latest_time=strftime(latestdaybefore,"%Y-%m-%dT%H:%M:%S")
| table earliest_time, latest_time, earliestdaybefore, latestdaybefore
| fields - _time</query>
<earliest>$earliestdaybefore$</earliest>
<latest>$latestdaybefore$</latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</table>
</panel>
</row>
</form>

@ITWhisperer

Re: How to populate one time picker based on the selection of another time picker?

ITWhisperer — Sun, 05 Jun 2022 12:25:07 GMT

Change the token initialisation

<init> <eval token="earliestdaybefore">relative_time(now(),"-1d@d")</eval> <eval token="latestdaybefore">relative_time(now(),"@d")</eval> </init>

Re: How to populate one time picker based on the selection of another time picker?

mnj1809 — Sun, 05 Jun 2022 12:30:01 GMT

Thanks, It works 🙂
@ITWhisperer

Re: How to populate one time picker based on the selection of another time picker?

mnj1809 — Sun, 05 Jun 2022 19:12:26 GMT

Hello,

The solution you provided to me is working well over my local environment (time zone is IST). I am successfully able to get the previous date wrt what is selected in the time picker.

But over my production environment (time zone is EST), it's not showing me the correct timestamp.

Please suggest.

@ITWhisperer