kql Query to get number of TriggersStarted per hour from last 7 days-CodePudding

I tried following query to get number of TriggersStarted per hour from last 7 days (24 hour * 7 day == 168 hour values for TriggerStarted values) I tried using the following query

 AzureMetrics
| where TimeGenerated between ( ago(7d) .. endofday(ago(1d)) )
| where MetricName == "TriggersStarted"
| summarize count() by Hour=datetime_part("Hour", TimeGenerated)
| summarize bn = min(count_)

i tweaked in some changes add tried different functions like bin and range functions but i didnt got accurate results. If anyone knows a good approach to get better results please guide me with some kind of examples or by suggesting some functions

CodePudding user response：

I'm assuming you are looking for something like this:

AzureMetrics
| where TimeGenerated between (startofday(ago(7d)) .. endofday(ago(1d)))
| where MetricName == "TriggersStarted"
| summarize count() by bin(TimeGenerated, 1h)
| order by TimeGenerated asc