Forum Discussion

steffen_zeidler's avatar
steffen_zeidler
Copper Contributor
Sep 21, 2020

Workbook Time Chart with UTC time needed

In a workbook the datetime in a grid is automatic shown as local time. I can change to UTC in the column settings. But there is no setting for UTC in a time chart.

Reference data formatting:

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/workbooks-grid-visualizations#custom-date-formatting

“Show time as   Allows the author to decide between showing the time in local time (default), or as UTC.”

  • For the chart we have two variations - is chart using metrics or logs ?
    • steffen_zeidler's avatar
      steffen_zeidler
      Copper Contributor
      The chart is using logs.
      KQL sample:
      range X from datetime(2020-10-20 8:00) to datetime(2020-10-20 9:00) step 1h
      | extend Y=1
      | render timechart

Resources