In App Analytics you can slice and dice on your App Insights custom dimensions and measurements just as easily as any of the so-called “standard” properties.
The only thing that’s a little bit tricky is extracting them first.
It’s tricky because of 2 things:
- You have to explicitly set the type of the measurement/dimension after you extract it.
- Extracting properties that contain spaces and special characters is a little bit of a hassle.
Here is an example of me doing both:
customEvents | where timestamp > ago(3h) | where name == "Query" | extend query_time = todouble(customMeasurements.['Query Time']) | extend query_name = tostring(customDimensions.['Query Name']) | project query_time, query_name | summarize avg(query_time) by query_name | render barchart
If you liked this, check out some other cool analytics queries: