Create a date-based filter using your companies fiscal calendar year. You must define the start of your fiscal calendar year by month before using it in a filter.
Define Fiscal Calendar Year by Month
Define the starting month of your fiscal calendar year. Select Administration > System Settings from the navigation bar.
Click on the Accounts tab inside System Settings.
Scrolls down to the "Fiscal calendar start" pick list. The default start month is January.
- Select the start month from the pick list.
- Click Save to save your changes.
Filter by Fiscal Calendar Year
You can now filter records by your fiscal calendar year using a date-based attribute. Filters can be created in jobs and analytic reports.
In a job, create a filter using the Filter Input button.
In a analytics report, create a filter using the Filter Data button. Follow below steps for either filter.
- Create a filter using a date-based attribute. (e.g. CreatedDate)
- Select "relative to" from the Time/Date Format pick list.
- Define the time/date by fiscal quarter before run time, fiscal years before run time, fiscal quarters after run time, or fiscal years after run time.
- Click Update Filter to save your filter.
Notes:
-
Define your fiscal calendar year to easily filter and review fiscal quarterly metrics for data quality or enrichment.