Display data in calendar weeks

[stefan_eggersto]

How can I aggregate my data into calendar weeks? This is a simplified version of my query:

fetch events
| summarize count(), by:{bin(timestamp, 7d)}

This chart shows the beginning of the weeks in the legend, but I'd like to display calendar weeks:

[educampver · Accepted solution]

Hi Stefan, you can achieve this with the formatTimestamp function, like so:

fetch events
| fieldsAdd week = formatTimestamp(timestamp, format: "w yyyy")
| summarize count(), by:{week}