Forum Discussion

Anonymous's avatar
Anonymous
Jul 11, 2019
Solved

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
  • Anonymous's avatar
    Anonymous
    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's avatar
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

 

 

  • Anonymous's avatar
    Anonymous
    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

Resources