The following query returns a table with three columns: timestamp, Requests, and RequestName, where RequestName is a categorical column with the names of requests. | summarize Requests = count(), Users = dcount(user_Id) by bin(timestamp, 1h) The query control uses timestamp for the x-axis and Requests and Users as separate series on the y-axis. The following query returns a table with three columns: timestamp, Requests, and Users. | summarize Requests = count() by bin(timestamp, 1h) The query control uses timestamp for the x-axis and Requests for the y-axis. The following query returns a table with two columns: timestamp and Requests. You must have time and metric information in the result set to create a time-series chart. You can use the workbook's query control to create time-series charts such as area, bar, line, scatter, and time.

Requests | make-series Requests = count() default = 0 on timestamp from ago(1d) to now() step 1h Sum or average of values or max, min, first, last valueĪny KQL query that returns data in the format expected by the chart visualization. The aggregation function to use for the legend. Ignored in multi-metric or segmented mode.

Set other parameters like time range, visualization, size, color palette, and legend, if needed.Īpplication Insights, Log Analytics, or Azure-firstĪ set of resources to get the metrics value from.Īrea, bar, line, pie, scatter, time, bar (categorical).

Set Visualization to Area, Bar, Bar (categorical), Line, Pie, Scatter, or Time.

Use the query editor to enter the KQL for your analysis.

For Resource type, select, for example, Application Insights, and select the resources to target.

Use the Add query link to add a log query control to the workbook.

Switch the workbook to edit mode by selecting Edit on the toolbar.

The following example shows the trend of requests to an app over the previous days. You can use workbooks to present log data as visual charts for user analysis.

Logs provide information about the state of the resource and data that's useful for diagnostics. Log information isn't collected by default, and you have to configure data collection. Log chartsĪzure Monitor logs give you detailed information about your apps and infrastructure. Workbooks support charts for both logs and metric data sources. You can also customize axis types and series colors by using chart settings. You can present monitoring data as charts. Workbooks can take the data returned from queries in various formats to create different visualizations from that data, such as area, line, bar, or time visualizations.

Pie chart timetable