Forum Discussion

Sam Larko's avatar
Sam Larko
Copper Contributor
Oct 17, 2018

How to rename axes in Azure Log Analytics Timechart Query

I have the following query that I want to change the name of the axes. I tried the optional attributes of render, but it doesn't seem to recognize any of them. What am I missing?

 

AzureStorage_CL
| where ResourceGroup == "rg-sdl-adw"
| where PercentClientOtherError_d > 0
| summarize AV = any(PercentClientOtherError_d) by bin(TimeGenerated, 30m) | 
render timechart with (ytitle = "Y new title")

Current Results:

 

azure monitor
Query Language

1 Reply

  • Stanislav_Zhelyazkov's avatar
    Stanislav_Zhelyazkov
    MVP
    Nov 02, 2018

    Hi,

    If I understand correctly you want to change the name of TimeGenerated below. That is just a column and you can do something like:

    AzureStorage_CL
| where ResourceGroup == "rg-sdl-adw"
| where PercentClientOtherError_d > 0
| summarize AV = any(PercentClientOtherError_d) by bin(TimeGenerated, 30m)
| project-rename NewName = TimeGenerated
 | render timechart

    Let me know if this works for you.