Page Comparison

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.

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.

Apply a custom period in the Purchases database to identify customers who have purchased products during the summer season (in the northern hemisphere).

1. Select the Customer dimension. 

2. Ensure you are in Period mode, then click Period > Custom.

3. In the Custom Period window, select Month and set the Current period start date to June and the end date to August. The Previous period will default to June to August in the previous year.

4. Click Apply. The grid updates to display only customers who purchased products during the summer. The columns will be June, July and August, from left to right (unless you selected the Reverse option) and the date range displays in the status bar.

Apply a custom period in the Sales database to compare products sales for the first half of October compared with the first half of September.

1. Select the Product dimension. 

2. Ensure you are in Period mode, then click Period > Custom.

3. In the Custom Period window, select Day.

4. Set the Current period start date to 1 October 2022 and the end date to 16 October 2022.

5. Set the Previous period start date to 1 September 2022 and the end date to 16 September 2022.

6. Click Apply. The grid updates to display all products sold during the first half of October (Current Period column) and the first half of September (Previous Period column) and the date range displays in the status bar.

To view a single month, the start and end need to be the same, as illustrated in the image below. 

Image Added

You can add your own 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.

Add a user-defined period from scratch

1. Click the Period menu and select Add at the bottom of the list.

2. In the User Defined Period window, enter a name for the period.

3. 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.

4. (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.

5. 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.

     Image Added

   • To define a date range based on today's date so that the data continues to update dynamically, use an offset date.

     Image Added

6. Click Save & Apply. The new period displays in the Period list and the grid updates to display the data for that period.

   Image Added

Add a user-defined period based on an existing 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.

1. Click the Period menu and select the defined period from the list. 

2. When the grid updates with the new defined period, click Period > Add.

3. In the User Defined Period window, enter a name for the period.

4. Adjust the dates as required.

5. Click Save & Apply. The new period displays in the Period list and the grid updates to display the data for that period.

Edit or delete a user-defined 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.