When you calculate dining area statistics, the program archives all dining area plans, dining table history entries and dining table receipt entries for the selected time frame and calculates from this archived data the statistics for the dining area.
Note: It is very important to calculate dining area statistics on a regular basis (up to once a day) to minimize the size of the database tables used in dining table management (Dining Table History Entry, Dining Table Receipt Entry and Dining Area Plan).
To calculate the statistics for a dining area
- Click the
icon, enter Calculate Dining Area Statistics, and select the relevant link. - Select the desired dining area in the Dining Area ID field. If no dining area is selected, the program will calculate the statistics for all dining areas.
- Select the date up to which you want to calculate statistics for. The number of dining area plans and dining table history entries that will be archived is visible in the window.
- Click OK.
The program displays a progress bar while archiving and calculating. When the calculation is completed, the program displays the Dining Area Plan Statistics page showing the resulting statistics for the period in question.
The program archives three tables that contain day-to-day information:
The program stores the statistics in two tables:
Note: Even if you have not set up dining area plans in your company, the Calculate Dining Area Statistics function archives the dining table history entries and dining table receipt entries. We do recommend, however, that you set up dining area plan templates to create dining area plans. You can create dining area plans in the past just to get statistics on your dining areas from the first day you have dining table history entries.