Issue with Column Order in Azure Monitor Dashboard Visualizations

Question

Hello,

I am experiencing an issue with arranging the order of columns in my Azure Monitor dashboard visualizations. Despite various attempts to control the order of columns through the query, the columns do not display in the specified order in the visualization.

Here is a simplified version of the query I am using, In the visualization, the SuccessfulRequests column appears before the RequestsCount column, despite specifying the desired order in the query.

Could you please provide guidance on how to enforce the correct order of columns in the visualization? Are there specific settings or query adjustments needed to control the order of columns in Azure Monitor dashboards?

Thank you for your assistance.

ContainerLog
| where LogEntry contains "Sample Request" and LogEntry contains "TESTENV"
| summarize RequestsCount = count() by Day=format_datetime(TimeGenerated, "MM-dd")
| join kind=leftouter (
    ContainerLog
    | where 
    (LogEntry contains "Error Type 1" or 
    LogEntry contains "Error Type 2" or 
    LogEntry contains "Error Type 3" or 
    LogEntry contains "Error Type 4" or 
    LogEntry contains "Error Type 5") and LogEntry contains "TESTENV"
    | summarize ErrorCount = count() by Day=format_datetime(TimeGenerated, "MM-dd")
) on Day
| project Day, RequestsCount, SuccessfulRequests = RequestsCount - ErrorCount
| order by Day asc

Answer 1

Hi @Miller, Kevin (External),

Since the Microsoft Q&A community has a policy that the question author cannot accept their own answer. They can only accept answers by others, Summarized and posted the solution that you shared, request you to Accept the answer, it will benefit the community find the answers quickly.

Scenario:

Issue with Column Order in Azure Monitor Dashboard Visualizations

Issue:

Despite specifying the desired order in the query, the columns in the visualization are not displayed as expected.

Things Tried:

Arranging the order of columns in Azure Monitor dashboard visualizations can be challenging, file generated by the script has columns arranged in alphabetical order.

Shared by @Miller, Kevin (External)

Answer 2

Hello, have you tried https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/project-reorder-operator ?

Answer 3

I figured it out. It seems the columns are arranged alphabetically. I spent a whole day trying to get them to rearrange lol!