The detailed statistics report will analyze a selection of Logs or Referrals and show:
- how many received;
- how many closed/completed;
- how many still open;
- a break down of how many days late; and
- average number of days to complete.
The statistics may be summarized at any of the following levels:
- Action;
- Log Type;
- Office; and
- Group.
To create a Detailed Statistics Report
You may pre-select the Logs or Referrals you wish to report on or you may use the search facilities in the Detailed Statistics Report.
Choose Detailed Statistics from the Report menu. CLIFF presents the Detailed Statistics Report window:
If you had pre-selected Logs or Referrals, the option Create Report for will show “Current Selection of ...”. If a current selection of records did not exist, CLIFF will simply put in the default of “Logs”.
You may change any of the following search parameters to fine tune your search. All options except Current Selection requires further selection criteria to be specified.
- Create Report for: choose between Logs, Referrals Sent, and Referrals Received.
- Date Range: choose one of the pre-defined periods or enter your own;
- Log Type: type of Logs to search for;
Action: Log or Referral action as appropriate. If report is on Logs then the Log Action will be tested, if reporting on referrals the Referral Action will be tested.
Select the Groups or Offices you wish to report on.
CLIFF defaults to all Offices. To select Groups you must first click the radio button at the top of the Group List. Click individual Offices or Groups as required.
Set the days overdue you want to calculated the statistics on. The report provides three counts of Logs (or Referrals) that were overdue at the end of the specified date range. The three counts are based on the parameters entered here. For example if 30 and 180 are used, counts will be provided for:
- 0 to 30 days overdue;
- 31 to 180 days overdue;
- more than 180 days overdue.
Show Totals: If you want CLIFF to calculate totals for each summary level click this check box.
Hide Log Type: If you don’t want results summarized by Log Type click this check box.
Repeated Values: If you want summary field names repeated on each line click this check box.
When selection criteria has been specified, click OK to produce the report.
CLIFF will build the report and display it in a window for you to preview.
The data columns are as follows:
- Logs/Refs Recvd - Logs/Referrals received in the date range;
- Logs Closed/Refs Comp - Logs closed/Referrals completed in the date range;
- Logs Open/Refs Open - Logs/Referrals still open at the end of the date range. This may include Logs/Referrals received before the date range.
- 0-30 Late - Logs/Referrals that were 0-30 days overdue at end of date range;
- 31-180 Late - Logs/Referrals that were 30-180 days overdue at end of date range;
- >180 Late - Logs/Referrals that were more than 180 days overdue at end of date range;
- Note that 30 and 180 days are used here as an example. If you specified different numbers for calculating statistics they will be used instead.
- Avg Days to Close - average number of days to complete each Log/Referral that was closed in the date range.
At the top of the print preview window you will have the following options available to you:
- Print - will invoke your web browser's printer interface. The window and options displayed will depend on your default printer specification. From the printer window you should be able to select the Page Setup which will allow you to choose between Landscape or Portrait layouts. The browser will automatically format the data to suit the selected layout. The browser option for page header and footer may not be available from the displayed printer interface. You may defined these from the browser's Page Setup menu.
- Close Window - close the Report window.
