Application Insights - How to sort by custom dimension Application Insights - How to sort by custom dimension azure azure

Application Insights - How to sort by custom dimension


What I would suggest is first extending 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.