Statistical

Stats

Count Summary

The Count Summary report produces a report with the number of unique occurances of field entries for a group of records.

To produce the Count Summary Report

  1. Choose Count Summary from the Report menu.
    The following window is displayed.


  2. Select the records to report on from the popup list.
  3. Select the data field to report on.

    CLIFF will build the report and display it in a window for you to preview. 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.
    • Download - CLIFF will reformat the report into a tab delimited text file which you may download to your computer.
    • Close Window - close the Report window.

    4. Turnaround

    The Turnaround report will analyze a selection of Logs and show the cradle to grave time of the logs (date received to date closed).

    To create a Turnaround Report

    You may pre-select the Logs you wish to report on or you may use the search facilities in the Turnaround Report.

    1. Choose Turnaround Report from the Report menu.
      CLIFF presents the Turnaround Report window.

      If you had pre-selected Logs, the option Create Report for will show Current Selection of Logs. If a current selection of records did not exist, CLIFF will simply put in the default of Logs.

    2. 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.
      • Date Range: choose one of the pre-defined periods or enter your own;
      • Summarize report by: select one of the user definable fields;
      • Turnaround based on: select either the close date (default) or one of the user definable dates. This date is used as the grave date (end date) for the cradle to grave time.
      • Ideal Turnaround: select an ideal turnaround. Counts are taken for those Logs meeting the turnaround time.
      • Show Details: when this check box is checked, individual Log records are reported.
      • Show Monthly Breaks: when this check box is checked, a summary line for each month is reported. The summary line shows the average turnaround.
    3. Click Continue to run the report.
    4. 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.

      5. Summary Statistics

      The Summary Statistics report analyzes the processing of Referrals by your office or other offices to whom you have sent Referrals. It includes the number of Referrals processed, and the average time to process them for an office or group of offices.

      To generate a Summary Statistics report

      1. Choose Summary Stats... from the Report menu. CLIFF displays the Summary Statistics Window.


          

      2. Select All Offices or a specific Office from the pop-up list.
      3. Enter a date range for Referrals to be analyzed.
      4. Click Continue.
        CLIFF will build the report and display it in a window for you to preview. 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.

        5. Detailed Statistics

        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.

        1. 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;

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

        4. 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.
        5. Show Totals: If you want CLIFF to calculate totals for each summary level click this check box.
        6. Hide Log Type: If you don’t want results summarized by Log Type click this check box.
        7. Repeated Values: If you want summary field names repeated on each line click this check box.
        8. 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.

          9. Trend Analysis

          The Trend Analysis report will analyze a selection of Logs and show the number of occurrences per month for the selected items in a pop-up field. 

          To create a Trend Analysis Report

          You may pre-select the Logs or Referrals you wish to report on or you may use the search facilities in the Trend Analysis Report. If the report is run against a selection of Referrals, the corresponding Logs for the Referrals are used in the report.

          1. Choose Trend Analysis from the Report menu.
            CLIFF presents the Trend Analysis 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.
          2. Select the Groups or Offices you wish to report on.
            Before you can select individual Groups or Offices, you must first click the radio button at the top of the list. Individual Groups or Offices are selected by clicking on the name.
          3. From the pop-up, select the field to report on.
            The table values for the selected pop-up field are shown in the scrolling list.
          4. Select the table values to report on by clicking on the name.
            Note that the first six table entries are automatically selected.
          5. Click Continue to run the report.
            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.