How to show local time on the X-Axis of a render timechart and not UTC?

Anyone know how to change the time on the x-axis of a render timechart graph in a Log Analytics query to local time? I tried setting Display Time Zone in Settings but that did not work. I have se...

azure monitor

Query Language

Deleted
Jul 12, 2019
CliveWatson
Thanks. There was a simple solution. I missed the Display Time pulldown on the top right side of the display panel :-)

Bill

CliveWatson

Former Employee

Jul 12, 2019

Deleted

This maybe?

Perf
| where (ObjectName == "Processor" and CounterName == "% Processor Time")
| summarize count() by bin(TimeGenerated,1hr)
| extend UTCtoPST = TimeGenerated - 7h  // convert UTC to PST
| project-away TimeGenerated            // remove the x-axis entry for UTC
| render timechart

https://portal.loganalytics.io/Demo?q=H4sIAAAAAAAAA12OwYrCQBBE74L%2FUAQWImyQPXnKycPe3IDxAyaxZLIwM9JpNRE%2Ffnv2ILv2tV69roZyWi4euHkKUX513%2Bx15wJR1ygaST3HMUkBF4%2FYpktUyjN%2BwxNAOwQWq6waLyE4Ge5En%2FlyhW5GN8QyI5%2BMFKc8vn94%2BcU5Kc19aLeamn2LGv84VNh4YL02W7xSNJPQBGNz%2FSwpT67czc0vzT9ndWFIV0I9MVVuGkYwqsw42XhTZpfYEArULL139mq5%2BAEimA5GIAEAAA%3D%3D&timespan=P1D

Deleted

Jul 12, 2019

CliveWatson

Thanks. There was a simple solution. I missed the Display Time pulldown on the top right side of the display panel :-)

Bill

Forum Discussion

How to show local time on the X-Axis of a render timechart and not UTC?

Resources