topic Re: How to enter selected Time period in the Chart title in a Dashboard? in Dashboards & Visualizations

How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 12:35:40 GMT

Hi there,

I have managed to enter other fields in Chart title, but I fail to get the selected time period visible with a dynamic variable in the title of a Chart.

So, I can do this chart title:

Time chart of Users and Journal notes ($care_unit_tok$)
Which after Care Unit selection = ASIH Botkyrka results in this title:
Antal användare och journalanteckningar (| where (care_unit = "ASIH Botkyrka"))

But I fail to do similar action with time_tok, e.g. like this:

Time chart of Users and Journal notes ($time_tok$)
But even if I have made a time selection which I can see in the filter as Jul 2023,
I only get this text over the Chart, without any time period displayed:
Time chart of Users and Journal notes

Thanks for any ideas on how to solve this.

Re: How to enter selected Time period in the Chart title in a Dashboard?

ITWhisperer — Fri, 11 Aug 2023 12:42:09 GMT

Probably going to need a bit more information

How is time_tok set? If you are using a time input widget, you can get $time_tok.earliest$ and $time_tok.latest$ as the earliest and latest values chosen.

However, I suspect this may not be in the format you want.

You could either use the change handler (if you have a Classic Dashboard) to evaluate a new token based on the either the earliest or latest time selected, or use the done handler for the panel search and evaluate a token based on the (first row of the) result of the search.

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 12:49:40 GMT

Hi @ITWhisperer, thanks!
I am actually updating a Dashboard created by my previous colleague.
So I have this filter already set up like this.

When I use the dashboard, the standard Time period selection comes up like this:

And then on the filter it looks like this in the Time Period selection filter:

Does that help?
I mean, somehow Splunk gets a value that it shows in the selection filter.

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 13:26:26 GMT

Hi, my answer disappeared. Sorry.

I am using the standard time selection filter in Splunk:

I tried your variables on another Chart:
Statuses ($time_tok.earliest$ - $time_tok.latest$)

Which rendered this result (which is as you say useless to me and the users):
Statuses (1688169600 - 1690848000)

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 13:14:29 GMT

Basically, I want the time for the time period of the search interval.
(Could be as "from-to", or as a dedicated month or year. I am not picky)

I do not need the time for the actual search results.

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 13:24:28 GMT

Now I found in the source code:

| stats count as cnt by Tenant</query>
<earliest>$time_tok.earliest$</earliest>
<latest>$time_tok.latest$</latest>
</search>

and further down:

<input type="time" token="time_tok">
<label>Period</label>
<default>
<earliest>-1y@y</earliest>
<latest>now</latest>
</default>
</input>

Re: How to enter selected Time period in the Chart title in a Dashboard?

ITWhisperer — Fri, 11 Aug 2023 14:19:09 GMT

Try something like this

<eval token="date">strftime($time_tok.earliest$,"%m %Y")</eval>

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 14:40:24 GMT

Thanks again, but that did not work either in the title:

I have also tried $form.time_tok$ (which worked wonders for other fields like $form.care_unit_tok$)
to no avail (-> empty result).

I have also tried $form.time$
(-> empty result)

Re: How to enter selected Time period in the Chart title in a Dashboard?

Norrmor — Fri, 11 Aug 2023 14:44:12 GMT

And when I enter your phrase inside the search code of that report I got this error:

Re: How to enter selected Time period in the Chart title in a Dashboard?

ITWhisperer — Fri, 11 Aug 2023 16:20:56 GMT

Try adding the line to the change handler for the time input widget