Time Series Column Labels
This information applies to time series columns in Matrix and Measures portlets.
Typically, Spectre time/date formats use specific, reserved letters to define the appearance of the date and time output, including:
- Y for year
- M for month
- W for week
- D for day of the month
- A for the day of the week
For example, specifying the format YYYY-MM-DD returns 2023-01-20 for January 20, 2023.
If you want one of these letters (Y, M, W, D, or A) to display in the output, you must escape the format description using a back slash. For example, "\Year: YYYY" returns Year: 2023.
Column labels (headings) use string data to define the column label, and you typically type the header into the label text box. Using formatted data is the exception for a column label. Therefore, when you want to specify a data element for a time series column heading, you must escape it using braces. For example {MMM}-{YYYY} returns Jan-2023.
The following label string data can be used for time series column labels in Matrix and Measures portlets.
| Bracketed label | Description | Sample output |
|---|---|---|
| YY | Last two digits of the year. | 21 |
| YYYY | Four-digit year. | 2021 |
| M | One- or two-digit month. | 2 |
| MM | Two-digit month. | 03 |
| MMM | Month abbreviation. | Oct |
| MMMM | Month name. | October |
| D | One- or two-digit days in a standard calendar, or weekday number in an ISO calendar. | 4 |
| DD | Two-digit calendar day. | 12 |
| FYYYY |
Four digit year—Same as YYYY, but respects the selected calendar type, including custom calendars. If a fiscal calendar is selected, it shows the fiscal year. If a standard calendar is selected, it shows the standard calendar year. |
2020 |
| FM | Fiscal one or two digit month—Same as M, but respects the selected calendar type, including custom calendars. | 6 |
| FMM | Fiscal one or two digit month—Same as MM, but respects the selected calendar type, including custom calendars. | 07 |
For more information, see