topic Re: Drilldown with timepicker in Dashboards & Visualizations

Drilldown with timepicker

MrJohn230 — Thu, 30 Nov 2023 00:09:39 GMT

I have a drilldown into another dashboard with parameters earliest=$earliest$ and latest=$latest$, this works. When I go into the drilldown dashboard directly it sets the data to come back as "all time".

Is there a way that I can have multiple defaults or some other constrain that doesn't cause this?

Here's what I've been working on but it's not working. Any feedback would be helpful...

<input type="time" token="t_time"> <default> <earliest>if(isnull($url.earliest$), "-15m@m", $url.earliest$)</earliest> <latest>if(isnull($url.latest$), "now", $url.latest$)</latest> </default> </input>

Re: Drilldown with timepicker

bowesmana — Thu, 30 Nov 2023 21:54:50 GMT

I'm not sure I fully understood your question, but Input field tokens are passed as form.token_name=value in the URL, so if your token is t_time in the target dashboard, you should pass form.t_time.earliest=X&form.t_time.latest=Y in the URL

Let me know if this helps

Re: Drilldown with timepicker

MrJohn230 — Thu, 30 Nov 2023 22:10:16 GMT

@bowesmana Appreciated the response.

I'm "linking to dashboard" when I create the parameter I'm using earliest = $earliest$ and latest = $latest$ and seems to be passing to the url fine via the drill-down dashboard. What is annoying it when I go directly into the drill-down dashboard, the timepicker defaults to "All Time". My question is how can this be avoided?

When I create the timepicker in the drilldown and set a default the "link to dashboard" parameters no longer work.

Re: Drilldown with timepicker

bowesmana — Thu, 30 Nov 2023 23:08:13 GMT

When you click to drilldown, what are the parameters passed on the url to the second dashboard

On the second dashboard, what is the XML for the time picker? If you go to the second dashboard directly without a link and it is showing all time as the default, that is because the time picker is configured to show all time - if you want to change that without a link, edit that second dashboard and change the default.

Please post the XML for the <drilldown> section in the source dashboard and the <input> time picker in the second dashboard.

Re: Drilldown with timepicker

MrJohn230 — Thu, 30 Nov 2023 23:44:27 GMT

@bowesmana When I click on the URL these parameters are being passed: ?earliest=1701381000&latest=1701384619

But when I add a new timepicker in the drill-down and set a default the URL becomes: ?earliest=1701381000&latest=1701384619&form.t_time.earliest=-15m&form.t_time.latest=now

Drill-down timepicker token _time default "last 15 minutes"

This is appended to the bottom of my spl (outside of the query tags)

<earliest>$t_time.earliest$</earliest>
<latest>$t_time.latest$</latest>

My timepicker XML looks like this:

Re: Drilldown with timepicker

bowesmana — Fri, 01 Dec 2023 03:48:08 GMT

The parameters you need to pass from dashboard A to dashboard B are form.t_time.* as that's the name of your time picker in dashboard B

As I said in my initial reply, input elements in dashboard have the token names PREFIXED with form. so if you want to pass from a dashboard to another dashboard where the input field is populated from the passed URL parameters, you need to prefix the target token with form.

Re: Drilldown with timepicker

MrJohn230 — Fri, 01 Dec 2023 14:12:54 GMT

@bowesmana Great, that works. This is what I have done.

Parameters for dashboard A

earliest = $form.t_time.earliest$

latest = $form.t_time.latest$

Then on dashboard B my timepicker should refer to dashboard A tokens, see below. (leaving out the token name). Now you can adjust your default accordingly, if you want the default to be your token then use $earliest$ $latest$ . But by setting your default to 15 minutes when you directly go to dashboard B you will not receive an error of missing earliest.