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:

1. You have to explicitly set the type of the measurement/dimension after you extract it.
2. 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:

• A Simple Way to Extract Data From Traces – ‘Parse’
• Using Azure Log Analytics to Calculate User Engagement Metrics
• Search in App Analytics