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)
Show Label on X-Axis
Selecting 'Hide' will hide the labels on the x-axis.
Period Flag
By default, the Big Number on the KPI cards shows the last value from the time series chart. You can get more control over this by using period flag. This flag has to be an boolean attribute (true/false) like
ATTR(DATETRUNC('month',[Order Date])=[Month Parameter]).
Drag this field to Detail, and map map it in the Period Flag dropdown.
This feature is for example useful, when you want to roll up the current year against the last year, and use the datepart of month as the datefield. A visual indicator will also be added in the trend chart to highlight the period that is being shown on the big number.
Period Flags can be metric-specific, except for the decomposition tree.
Last updated