@Niels Beukenkamp - The
json.total fields are used to represent the values of a specific metric that is collected by Azure Monitor Logs.
A metric is a numerical value that describes an aspect of a system at a particular point in time. For example, CPU usage, memory usage, and network traffic are all examples of metrics that can be collected by Azure Monitor Logs.
When you run a query to collect a specific metric, Azure Monitor Logs will return a table with the
json.total fields, which represent the values of that metric.
For example, if you run a query to collect the CPU usage of a virtual machine, the
json.count field will show the number of CPU usage values that were collected, the
json.maximum field will show the maximum CPU usage value, the
json.minimum field will show the minimum CPU usage value, the
json.average field will show the average CPU usage value, and the
json.total field will show the sum of all the CPU usage values.
I hope this helps! Let me know if you have any other questions.