Application Insights - how to sort by user size

Question

I would like to sort the results of my query according to customDimension.MyCustomPropertywhich is present in all entities and is a number. How can i do this?

Answer 1

What I would like to suggest is first extendyour result set using customDimension. Then you will need to cast the new column to a string, integer or double. The reason for this is what customDimensionsis considered a dynamic column

Quick example:

traces
| extend sortKey = toint(customDimensions.MyCustomProperty)
| order by sortKey asc

Casting Options:

• to string()
• toint ()
• double ()

, project-away .