All Apps and Add-ons

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

alvin_kwong
Engager

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
    alt text

  • The user with timezone setting as GMT
    alt text

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

1 Solution

to4kawa
Ultra Champion
| 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")

View solution in original post

0 Karma

to4kawa
Ultra Champion
| 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")

0 Karma

ahartge
Path Finder

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...