Is there a way to make an Application Insights kusto query sort on performanceBucket ‘correctly’, i.e. on bucket duration? When I summarize or sort using performanceBucket and don’t specify a sort I get something like this (note for example that 1-3sec is not adjacent to 3-7sec):

enter image description here

If I add a sort by performanceBucket it’s done alphanumerically:

enter image description here

I want it to be in this order (or the reverse of it)

  • <250ms
  • 250ms-500ms
  • 500ms-1sec
  • 1sec-3sec
  • 3sec-7sec
  • 7sec-15sec
  • 15sec-30sec
  • 30sec-1min
  • 1min-2min