Application Insights - How to sort by custom dimension
What I would suggest is first extend
ing your result set with your customDimension. Then you'll have to cast your new column to either a string, an int or a double. The reason for this is that customDimensions
is considered a dynamic column
A quick example:
traces| extend sortKey = toint(customDimensions.MyCustomProperty)| order by sortKey asc
The casting options are:
- tostring()
- toint()
- todouble()
If you want to remove the sorting key after the actual sort, you can project-away
the new column.