Azure Application Insights - Sum by Timestamp Part

Question

How can I sum records by year, month, day and hour only?

+3

Leonardo 06 June 17 at 13:29

1 answer

Jeremy Hutchinson · Accepted Answer · 2017-06-06T15:29:54+0000

In App Insight Analytics:

By the hour:

requests 
 | summarize count() by bin(timestamp, 1h)

By days:

requests 
 | summarize count() by bin(timestamp, 1d)

Monthly

requests 
  | summarize count()  by bin(datepart("Month", timestamp), 1)

On years

requests 
  | summarize count()  by bin(datepart("Year", timestamp), 1)