Splunk Search

Timechart in Local Timezone

gurkiratsingh
Explorer

Hi I am trying to make a time chart visualisation but I want it to be in IST(Indian Standard Time).


| eval received = strptime('timestamp', "%Y-%m-%dT%H:%M:%S.%3N")
| eval received_IST = received + 19800
| eval IST = strftime(received_IST,"%Y-%m-%d %H:%M")
| timechart count by Status

Status is a column which is consisting of true and false in string data type. In IST variable I have the timestamp in IST but how to implement it in the timechart? It is automatically picking up the (_time) by default

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Have you tried setting the timezone for your user to IST?

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Your user's timezone setting applies to your user only. In general I recommend setting the right timezone instead of messing around with adding/subtracting seconds manually.

0 Karma

gurkiratsingh
Explorer

No the timezone is set to default. I have many live dashboards on my account in which I am already using the conversion of timestamps from UTC to IST. So I do not want to make any sudden change which shall cause any malfunction in the dashboards as many people are using them. If I do the change will there be any such affect do you have any idea?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...