Display data in calendar weeks

stefan_eggersto — Wed, 31 May 2023 13:55:55 GMT

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:

Re: Display data in calendar weeks

educampver — Thu, 01 Jun 2023 11:07:37 GMT

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}