Change the period (Analytics)
Last updated
Last updated
Periods are a core concept in Phocas. Read the Phocas basics > Periods page to learn more about the Period menu and the different types of periods. You use the Period menu to change the timeframe that applies to the data in the grid.
The Reset tool does not work for the Period menu.
Watch these Phocas Academy videos:
In the Summary view or when you have selected a dimension (as applicable), click the Period menu to view the list of defined periods, then select the one you want to apply. The grid updates automatically.
During your analysis, you might wonder why you do not see certain data in the grid. A common reason for missing data is that the data is not represented in the period that is currently applied to the grid. You should check the dates in the period to ensure the data you are looking for is within that range. If it is not, you can change the period to view the required data.
There are two ways you can find out the date range for a particular defined period:
Apply the period, then click the Information button in the top right toolbar. The period details display in the Information window. Click Close to return to your analysis.
(If you have permission) Apply the period, then when the grid updates, click the Period menu and select Custom. The Custom Period window displays the dates for that period. Click Close to return to your analysis.
User permission: Query > Apply Custom Period
Click the Period menu and select Custom.
In the Custom Period window, select the period type (time unit), such as year, month or day. The period types that are available depend on what was set up by your administrator when the database was created.
(Optional) Select the Reversed checkbox. By default, time units (years, months, weeks or days) display in the grid in chronological order from left to right. To avoid having to scroll across to the most recent time unit, you can reverse the display order.
Select a start and end date for your current period. The previous period automatically updates accordingly (one year earlier) but you can change those dates too, if required.
Click Apply. The Custom option displays in the Period menu and the grid updates to display the data for that period. The period range you set displays in the status bar above the grid.
(Optional) Save the results as a favorite to include the custom period.
If you think your defined period would be useful to other users, ask your administrator to set a new period type in the database, so all users (provided they have permission) can see it in the Period list.
User permissions: Query > Apply Custom Period and Save User Defined Period
You can add your own user-defined period from scratch or tweak an existing defined period, then add it as a new defined period. Either way, as it is your defined period, you can edit or delete it as required.
Click the Period menu and select Add at the bottom of the list.
In the User Defined Period window, enter a name for the period.
Select the period type (time unit), such as year, month, or day. The available period types depend on what your administrator set up when the database was created. You will typically see year, month, and day, but week and quarter are also common.
(Optional) Select the Reversed checkbox. By default, time units (years, months, weeks, or days) display in the grid in chronological order from left to right. To avoid having to scroll across to the most recent time unit, you can reverse the display order.
Select the start and end dates for your Current and Previous periods.
When you set up the Current period date range, the Previous period automatically updates accordingly (one year earlier), but you can change that too, if required.
When defining a date range based on months, you can select either a month in a fixed year or one of two dynamic options: Most recent (the past 12 months) or Second most recent (the 12 months prior to that). Using a dynamic option is a simple way to get a date range that updates each year, and it saves you from having to manually update dates when you roll over into a new calendar or financial year. For more information and examples, see the Offset dates page.
To define a date range based on today's date so that the data continues to update dynamically, use an offset date.
Click Save & Apply. The new period displays in the Period list and the grid updates to display the data for that period.
You can use a period you have already created as the basis for another period. This is useful if you want to make a small change, as it saves you time.
Click the Period menu and select the defined period from the list.
When the grid updates with the new defined period, click Period > Add.
In the User Defined Period window, enter a name for the period.
Adjust the dates as required.
Click Save & Apply. The new period displays in the Period list and the grid updates to display the data for that period.
You can change the setup of a defined period you add, or delete it if you no longer need it.
Click the Period menu and locate the period in the list, then either:
Click the Edit button next to the period name, make your changes and click Save & Apply. Any existing favorites or widgets will update to reflect the changes.
Click the Delete button next to the period name and click Yes to confirm. The period disappears from the Period list.
