Skip to main content
OCLC Support

Statistics entity

Find information about the Statistics entity in Amlib OpenReports.

Issues by location and borrower type with graph

Skills outlined in this Sample – Test using Table and then display a Graph using an x and y axis, using Statistics Count from the database, setting Financial Year from the Calendar,

When choosing Statistics Reports:

  1. It is best to take away the Show details option so that just the relevant Counts show
  2. It is also possible to select one Location to pinpoint statistics at each Location
  3. Group the report in a logical fashion
  4. Order the report in a logical fashion
  5. Use the special Statistics Count to count the figures based on the Filters used
  6. Graphs can be used effectively within the Statistics area
  7. The Statistics Type is an important element of the Report as it will determine which Statistics to report on. The listing of Statistics Type can be found in Amlib under Supervisor/Stats Params

 

  1. Access the Report Designer TAB
  2. Select New from the buttons
  3. The Edit Report Window will display
  4. Enter a Report Title in the Report Title section.. For the sample for example “Issues by Location and Borrower Type”.
  5. Enter a Group since we want to find it later easily – for example Statistics
  6. Enter a Sub Group – for example Issues by Borrower Type
  7. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample) We will test it as a Table and then change it to graph when we are happy with the results
  8. Select Orientation
    • Landscape (select for the sample)
  9. Leave Show sql
  10. Show details: For this sample Report we will set to None because we only want the figures
    • None: We want only the raw figures which we will later plot on a graph
  11. Show Sub totals: Tick to get Subtotals.
  12. Show total: Tick to get Totals.
  13. Private. Leave this unticked.
  14. Show header on first page: This is your choice. But for now leave this unticked
  15. Show header on next pages: This is your choice. But for now leave this unticked

Display Fields

  1. Select the Statistics Entity
  2. Drag and drop Statistics Count into the Display Fields Table. This is a special count from the Statistics Database. Ensure the Format shows Sum

Group Fields

1. Drag and drop the Statistics Borrower Type to the Group Fields table

Filter

The Filter can be selected to target exactly the data required. For example: Filter the Statistics by Financial Year

  1. Drag and drop Statistics Transaction Date to the Filter column
  2. Select Greater than or equal
  3. Select the beginning of the Financial Year using the Calendar
    • Highlight the correct Year – for example 2014. Select the dates by using the wheel on the mouse – scroll down to select Months in the past, and scroll up to get dates in the future
    • Highlight the correct Month for example June.
    • Highlight the correct Day for example 1. Select the dates by using the wheel on the mouse – scroll down to select Months in the past, and scroll up to get dates in the future
  4. Drag and drop Statistics Transaction Date once again to the Filter column
  5. Select Less than
  6. Select the end of the Financial Year using the Calendar
    1. Highlight the correct Year 2015
    2. Highlight the correct month June
    3. Highlight the correct day 30
    4. Select out of the Calendar and the correct date will be set in the Field
  7. Drag and drop Statistics Transaction Type to the Filter column
  8. Select the required Statistics Type codes – for example, Issues
  9. Drag and drop Statistic Location to the Filter column
  10. Select Equal
  11. Select the required Location – for example Chelsea

Preview

Select Preview to view the Report

If the Table report is fine, it is possible to change the Report Type from the Drop-down options to Chart

Chart

  1. Select the Report Type of Chart
  2. Select the Chart Type

    For example Column
     
  3. Select the Chart Palette

    For example Light

  4. Select the Orientation – for example Landscape
  5. Once Chart is selected the Data Fields become the y-axis and the Group becomes the x- axis
  6. Preview the Report

Save

Once the Report is successful, select Save to be available in the Report Viewer as a graph

Summary of activity 2015 

  1. Access the Report Designer TAB
  2. Select New from the buttons
  3. The Edit Report Window will display
  4. Enter a Report Title in the Report Title section.. For the sample for example
    Summary of Statistics 2015
  5. Enter a Group since we want to find it later easily – for example Statistics
  6. Enter a Sub Group – for example Summary
  7. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample) We will test it as a Table and then change it to graph when we are happy with the results
  8. Select Orientation
    • Landscape (select for the sample)
  9. Leave Show sql
  10. Show details: For this sample Report we will set to None because we only want the figures
    • None: We want only the raw figures to give us a summary
  11. Show Sub totals: could be ticked.
  12. Show total: could be ticked.
  13. Private: leave this unticked.
  14. Show header on first page: This is your choice. But for now leave this unticked
  15. Show header on next pages: This is your choice. But for now leave this unticked

Display Fields

  1. Select the Statistics Entity
    1. Drag and drop Statistics Count into the Display Fields Table. This is a special count from the Statistics Database. Ensure the Format shows Sum

Group Fields

Drag and drop the Statistics Type Details to the Group Fields table

Filter

The Filter can be selected to target exactly the data required. For example: Filter the Statistics by Financial Year

  1. Drag and drop Statistics Transaction Date to the Filter column
  2. Select Greater than or equal
  3. Select the beginning of the Financial Year using the Calendar
    1. Highlight the correct Year – for example 2014. Select the dates by using the wheel on the mouse – scroll down to select Months in the past, and scroll up to get dates in the future
    2. Highlight the correct Month for example June.
    3. Highlight the correct Day for example 1. Select the dates by using the wheel on the mouse – scroll down to select Months in the past, and scroll up to get dates in the future
  4. Drag and drop Statistics Transaction Date once again to the Filter column
  5. Select Less than
  6. Select the end of the Financial Year using the Calendar
    1. Highlight the correct Year 2015
    2. Highlight the correct month June
    3. Highlight the correct day 30
    4. Select out of the Calendar and the correct date will be set in the Field
  7. Drag and drop Statistics Location to the Filter column
  8. Select the required Statistics Location code/s. For example, Chelsea Library only
  9. Drag and drop Statistics Transaction Type to the Filter column
  10. Select the required Statistics Type codes – for example, 05 Issues, 06 Returns, 07 Borrower Visits, 10 Returns, 16 Satisfied Reserves, 80 New Borrowers, 90 New Items, etc.

Preview

Select Preview to view the Report

Another Example

Issues for 2014 grouped by Stats codes