In this article
Studio allows for custom fiscal calendars to be defined and applied to both table and chart widgets, changing the default labels to fiscal period format.
What is a Fiscal Calendar?
In Studio, non-standard calendar periods can be used as a basis for reporting on dates. This means that a fiscal year can start in a month other than January or a fiscal month can be a duration different from a calendar month. These custom calendars can be applied to both table and chart widgets.
Defining a Fiscal Calendar
You can upload your Fiscal Calendar definitions in the Company Settings section of Professional Authoring. For more details, check the Professional Authoring documentation under the Company Settings section.
Using Fiscal Calendars in Studio
After defining a Calendar in Professional Authoring, it becomes available for date reporting in Studio.
Applying a Fiscal Calendar to your report
To apply a Fiscal Calendar to your report, follow these steps:
Click the Settings icon in the sidebar.
Click the "Calendar" drop-down menu.
Click the "First Week of a Year" drop-down menu.
First Day
First Full Week
First Four Day Week
Click the Week Starts On drop-down menu. From here you can select:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
To select the calendar you created in Defining a Calendar above, click the Calendar drop-down menu and choose its name from the options.
From here you can select:
Results
Applying a Calendar to your report changes the default labels in chart axes and table headings from the calendar period to the fiscal period.
In a table
Before applying a fiscal calendar in a table
After applying a fiscal calendar in a table
In a Chart
Before applying a fiscal Calendar in a chart
After applying a fiscal calendar in a chart
Default Labels
The table depicts how default labels are converted to Fiscal format.
| Period | Format | Output | Fiscal format | Fiscal output |
| year | "{year}" | 2022 | "FY {year}" | FY 2022 |
| quarter | Q{quarter}" | Q1 | "FQ{quarter}" | FQ1 |
| month | "{month}" | February | "{month}" | January |
| week | "W{week}" | W1 | "FW{week}" | FW1 |
| day | "{day}" | 7 | "{day}" | 7 |
| weekday | "{weekday}" | Monday | not applicable | |
| hour | "{hour}" | 16 | not applicable | |
| calendarQuarter | "Q{quarter} {year}" | Q1 2022 | "FQ{quarter} {year}" | FQ1 2022 |
| calendarMonth | "{month} {year}" | February 2022 | "{month} {year}" | January 2022 |
| calendarWeek | "W{week} {year}" | W1 2022 | "FW{week} {year}" | FW1 2022 |
| calendarDate | "{day}.{month:M}.{year}" | 4.2.2022 | "{day}.{month:M}.{year}" | 4.2.2022 |
Reporting Period Integration
When you apply a Fiscal Calendar to your report, the Reporting Period Filter will start to display Fiscal dates:
Reporting period filter displaying fiscal
Overriding Fiscal Calendar Settings
It is possible to override the Fiscal Calendar settings on a page or widget level.
Overriding Fiscal Calendar Settings on a Page Level
To ignore the fiscal calendar:
Click the ellipsis next to the name of the page.
Select "Edit Page".
Go to Filter and click the Ignore fiscal calendar button.
Overriding Fiscal Calendar Settings on a Widget Level
Click the edit widget icon
Choose "Filter" from the drop-down menu.
Click the Ignore fiscal calendar button.