topic Re: Horizon Chart - How can I change the axis based on user's timezone? in All Apps and Add-ons

Horizon Chart - How can I change the axis based on user's timezone?

alvin_kwong — Thu, 19 Jul 2018 06:55:46 GMT

Recently I observed that the axis in Horizon Chart is not following the timezone setting by the user. Please refer to the images below,

The user with timezone setting as GMT+0800
The user with timezone setting as GMT

Do I have any method that I can apply the timezone configured by the user in Splunk on the axis?

Re: Horizon Chart - How can I change the axis based on user's timezone?

ahartge — Mon, 18 Nov 2019 23:45:07 GMT

I know its over a year later - but did you resolve this ? I would like to know why Horizon Chart doesnt use the localised _time generated by | timestamp but instead uses the UTC timestamp from the event

Re: Horizon Chart - How can I change the axis based on user's timezone?

to4kawa — Tue, 19 Nov 2019 11:37:05 GMT

| makeresults count=2
| streamstats count
| eval _time = if (count==2,relative_time(_time,"-24h@m"), relative_time(_time,"@m"))
| makecontinuous span=30m
| eval col1=random() % 20, col2=random() % 20, col3=random() % 20
| fieldformat _time = strftime(_time,"%c %:::z")
| table _time col*
| eval COMMENT AS "this is sample data"

It runs in local time

In the worst case, add the following command:
| eval _time = relative_time (_time, "The timezone offset from UTC")