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

 

Thanks

Bill Zack

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

2 Replies

Sort By
  • 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