I’ve got a custom event that gets logged into Application Insights with a true/false value. The event can get raised any time and so I want to see visually the trend of when the custom event with a false value is created ideally as a line graph.

My current query:

customEvents
| where name contains 'Transaction Posted'
| order by timestamp
| where customDimensions.["Is Successful"] == "False"

Graph:

That graph isn’t particularly useful as the value on the y axis is either 1 or 0. Instead I think it would be more useful to count the number of events raised in each 10 minute block and point them instead on the y axis. How can I modify the query to do this?