SOLVED

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

Deleted
Not applicable

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 seen a few references to that as being a bug.

 

Thanks

Bill Zack

2 Replies

@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 

Go to Log Analytics and Run Query

 

 

best response confirmed by Stanislav Zhelyazkov (MVP)
Solution

@CliveWatson 

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

 

Bill