Azure Application Insights - Summarize by part of timestamp

Question

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

Answer 1

In Application Insights Analytics:

By hour:

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

By day:

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

By month

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

By year

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