Forum Discussion
Newtznewton98
Jun 19, 2024Copper Contributor
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
- MisterEM
Microsoft
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