Splunk Search

Configure an emailed report with timechart to display in local time rather than GMT?


I have a report of proxy logs that is emailed to me every evening. The logs themselves are in GMT. I set the time frame for Today.

When I view the report in my browser, the timechart shows from 00:00 - 24:00 (next day) since my account setting is set to display using my local time. However, the report I receive via email has the timechart start from 05:00 - 05:00 (next day). The report also includes a table below the chart but that shows up fine. People who aren't used to reading GMT have a hard time translating the timechart time to local in their heads.

How can I edit my search query to have the emailed report show the timechart with hours based on my local time? I would accept a hardcoded method that doesn't account for daylight savings if that makes things easier. Then I only have to adjust the report twice a year.

Web view of report (working how I want)
alt text

Emailed PDF of report (not how I want)
alt text

I tried using the solution posted here but none seemed to work for me (in displaying both the graph and table correctly).

0 Karma
Get Updates on the Splunk Community!

Streamline Data Ingestion With Deployment Server Essentials

REGISTER NOW!Every day the list of sources Admins are responsible for gets bigger and bigger, often making the ...

Remediate Threats Faster and Simplify Investigations With Splunk Enterprise Security ...

REGISTER NOW!Join us for a Tech Talk around our latest release of Splunk Enterprise Security 7.2! We’ll walk ...

Introduction to Splunk AI

WATCH NOWHow are you using AI in Splunk? Whether you see AI as a threat or opportunity, AI is here to stay. ...