topic Re: Split a Report in Weeks in Reporting

Split a Report in Weeks

Oti47 — Tue, 02 Oct 2012 09:14:26 GMT

Hello,
I'd like to split a Report in Weeks.
I use a time chart report with span=1week, but the y-axis display the first day of a week.

XXX | timechart span=1week sum(NWert) AS Umsatz

How could i change the display of the x-axis in Weeks like this 22, 23, 24, 25?

Thanks
Oti

Re: Split a Report in Weeks

echalex — Tue, 02 Oct 2012 09:35:49 GMT

Hi Oti47,

Rather than using timechart, use chart by week. You'll get the weeknumber from strftime:

XXX | eval week=strftime(_time,"%V") |chart sum(NWert) AS umsatz by week

HTH,

Re: Split a Report in Weeks

Oti47 — Tue, 02 Oct 2012 09:50:52 GMT

Thanks.

Works for me.

Re: Split a Report in Weeks

echalex — Tue, 02 Oct 2012 14:01:02 GMT

Glad it worked. Feel free to accept the answer as the correct one, so others can see it's solved.

Re: Split a Report in Weeks

echalex — Thu, 04 Oct 2012 06:08:14 GMT

Note!

This works for the ISO 8601 standard, where a week starts on Monday and the first week of the year is the first to have at least four days of the new year in it. Iow. if 1st Jan is on a Friday, its week number is 53 of the last week.

Users who would like to have the week starting on a Sunday, should consider using %U rather than %V.