Forum Discussion

Newtznewton98's avatar
Newtznewton98
Copper Contributor
Jun 19, 2024

How to render column charts in Logic Apps using Run query and visualize results connector

Team,

 

I have been trying to run a kql query and render results in column chart , but i couldnt as currently "Run query and visualize results connector" support only bar, line and pie chart ? Is there any solution for this 

  • Hi,

    If you're trying to run a KQL query and render the results in a column chart, but are finding that the "Run query and visualize results" connector only supports bar, line, and pie charts, there is a solution. You can use the render operator in your KQL query to create a column chart. Here's an example of how you can do this:

    T | summarize Count = count() by Category | render columnchart

    This query will summarize the data by category and render the results as a column chart. You can customize the chart further by using additional properties with the render operator, such as xcolumn, ycolumns, title, and more.

    Additional resources

    Column chart visualization - Kusto | Microsoft Learn

    render operator - Kusto | Microsoft Learn

Resources