none
Is there any way to sort logs based on customDimensions.["LoggedTimeUtc"]? RRS feed

  • Question

  • I tried doing 

    customEvents
    | where operation_Id == "123"
    | order by customDimensions.["LoggedTimeUtc"] desc

    but error Invalid sort key column

    Friday, June 30, 2017 3:20 PM

All replies

  • You have to first convert your custom dimension and then sort / order by it.

    customEvents
    | where operation_Id == "123"
    | extend utcTime = todatetime(customDimensions.["LoggedTimeUtc"])
    | sort by utcTime asc

    Wednesday, July 5, 2017 4:12 PM