Dates
A few date setting can be changes in the Dates section.
Dates across cards
By default, the big numbers and the last mark of the time series chart show values for the most recent date across all periods. In case that there is no data for this period for all cards, you can select the option to show the latest available date per card.
Number of periods in chart
Define the number of periods shown in the charts. The charts will adjust nicely depending on the selected number of periods.
Date format for axis labels
Depending on the selected datepart or datetrunc for the time series chart, axis labels need to be adjusted. While the extension smartly changes the format when dragging on the date field, you can specify the label here. There, use the following logic to get your desired label formats:
%b: Abbreviated month (e.g., Jan, Feb)
%m: Month as a number (01–12)
%y: Year (last two digits, e.g., 23 for 2023)
%Y: Full year (e.g., 2023)
%d: Day of the month (01–31)
%U: Week number (starting from Sunday)
%q: Quarter (1–4)
Example Formats:
%b-%y → Jan-23 (Month-Year)
%Y-%m-%d → 2023-09-30 (Year-Month-Day)
%y-w%U → 23-w40 (Year-Week Number)
%Y-Q%q → 2023-Q3 (Year-Quarter)
Last updated