SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-751202%22%20slang%3D%22en-US%22%3EHow%20to%20show%20local%20time%20on%20the%20X-Axis%20of%20a%20render%20timechart%20and%20not%20UTC%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751202%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20know%20how%20to%20change%20the%20time%20on%20the%20x-axis%20of%20a%20render%20timechart%20graph%20in%20a%20Log%20Analytics%20query%20to%20local%20time%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20setting%20Display%20Time%20Zone%20in%20Settings%20but%20that%20did%26nbsp%3Bnot%20work.%20I%20have%20seen%20a%20few%20references%20to%20that%20as%20being%20a%20bug.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EBill%20Zack%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-751202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751970%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20local%20time%20on%20the%20X-Axis%20of%20a%20render%20timechart%20and%20not%20UTC%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751970%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323676%22%20target%3D%22_blank%22%3E%40BillZack1234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20maybe%3F%3C%2FP%3E%0A%3CPRE%3EPerf%0A%7C%20where%20(ObjectName%20%3D%3D%20%22Processor%22%20and%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22)%0A%7C%20summarize%20count()%20by%20bin(TimeGenerated%2C1hr)%0A%7C%20extend%20UTCtoPST%20%3D%20TimeGenerated%20-%207h%20%20%2F%2F%20convert%20UTC%20to%20PST%0A%7C%20project-away%20TimeGenerated%20%20%20%20%20%20%20%20%20%20%20%20%2F%2F%20remove%20the%20x-axis%20entry%20for%20UTC%0A%7C%20render%20timechart%20%0A%3C%2FPRE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FDemo%3Fq%3DH4sIAAAAAAAAA12OwYrCQBBE74L%252FUAQWImyQPXnKycPe3IDxAyaxZLIwM9JpNRE%252Ffnv2ILv2tV69roZyWi4euHkKUX513%252Bx15wJR1ygaST3HMUkBF4%252FYpktUyjN%252BwxNAOwQWq6waLyE4Ge5En%252FlyhW5GN8QyI5%252BMFKc8vn94%252BcU5Kc19aLeamn2LGv84VNh4YL02W7xSNJPQBGNz%252FSwpT67czc0vzT9ndWFIV0I9MVVuGkYwqsw42XhTZpfYEArULL139mq5%252BAEimA5GIAEAAA%253D%253D%26amp%3Btimespan%3DP1D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EGo%20to%20Log%20Analytics%20and%20Run%20Query%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752655%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20local%20time%20on%20the%20X-Axis%20of%20a%20render%20timechart%20and%20not%20UTC%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20There%20was%20a%20simple%20solution.%20I%20missed%20the%20Display%20Time%20pulldown%20on%20the%20top%20right%20side%20of%20the%20display%20panel%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBill%3C%2FP%3E%3C%2FLINGO-BODY%3E
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