Let's go through how to create a custom time format for you axis in a chart.
The below chart shows resolution rate over time. We want to change the time format on the X-Axis so that we see ticks based on the week of the year instead.
Start editing the chart and head in to the customize tab. Scroll down to the X-Axis section and click into the Time Format box.
Now we we write our own formatting syntax. (At the bottom of this article is a list of date syntax references). To get the week number by year we can write
%Y-W%V
This will give us the format "2024-W11".
%a- abbreviated weekday name.%A- full weekday name.%b- abbreviated month name.%B- full month name.%c- the locale’s date and time, such as%x, %X.%d- zero-padded day of the month as a decimal number [01,31].%e- space-padded day of the month as a decimal number [ 1,31]; equivalent to%_d.%f- microseconds as a decimal number [000000, 999999].%g- ISO 8601 week-based year without century as a decimal number [00,99].%G- ISO 8601 week-based year with century as a decimal number.%H- hour (24-hour clock) as a decimal number [00,23].%I- hour (12-hour clock) as a decimal number [01,12].%j- day of the year as a decimal number [001,366].%m- month as a decimal number [01,12].%M- minute as a decimal number [00,59].%L- milliseconds as a decimal number [000, 999].%p- either AM or PM.*%q- quarter of the year as a decimal number [1,4].%Q- milliseconds since UNIX epoch.%s- seconds since UNIX epoch.%S- second as a decimal number [00,61].%u- Monday-based (ISO 8601) weekday as a decimal number [1,7].%U- Sunday-based week of the year as a decimal number [00,53].%V- ISO 8601 week of the year as a decimal number [01, 53].%w- Sunday-based weekday as a decimal number [0,6].%W- Monday-based week of the year as a decimal number [00,53].%x- the locale’s date, such as%-m/%-d/%Y.%X- the locale’s time, such as%-I:%M:%S %p.%y- year without century as a decimal number [00,99].%Y- year with century as a decimal number, such as1999.%Z- time zone offset, such as-0700,-07:00,-07, orZ.%%- a literal percent sign (%).