This example was created by Jim Rickerson at Clayton State University.

Instructions for creating a pivot table with usage by month and year (chronological) with totals for each year. This report could easily be changed to show Fiscal month and year. The usage statistics were obtained with SUSHI harvesting. More information about loading COUNTER Reports in Alma can be found on the Loading COUNTER Reports wiki page.

Total Item Requests by Month and Year

This example was created by Jim Rickerson at Clayton State University.

This example shows you how to create a monthly line graph with multiple years of usage for comparison. Statistics were obtained with SUSHI harvesting. More information about loading COUNTER Reports in Alma can be found on the Loading COUNTER Reports wiki page.

Total Item Requests by Month and Year

This example was created by Jim Rickerson at Clayton State University.

The usage statistics were obtained with SUSHI harvesting. More information about loading COUNTER Reports in Alma can be found on the Loading COUNTER Reports wiki page. This example shows how to create a 3D pie chart.

Collection Development Report by Material Type

This example was created by Jim Rickerson at Clayton State University.

This report indicates where there may be an overlap between physical and electronic holdings. Answers such questions as which subject areas have higher rates of duplication and are these rates too high?

Cleanup Report

This example was created by Jim Rickerson at Clayton State University.

This report identifies portfolios with static URLs. Knowing which portfolios have static URLs is useful if a vendor changes their link format or may indicate those portfolios where you may wish to check if there is a CZ record with parser parameters which could be activated instead.

Collection Development Report

This example was created by Jim Rickerson at Clayton State University.

This report can be filtered by electronic or physical books. It shows the number of titles held by decade and LC Classification. This data can help determine the currency of your collections.

Usage Report

This example was created by Jim Rickerson at Clayton State University.

This report provides COUNTER 5 usage by fiscal year for different metrics (searches, requests) and provides a grand total for each row. It can be used to gauge user engagement with a resource and can easily be tweaked to provide information on investigations or displayed as a table or graph.

How To Video - full screen

This example was created by Jim Rickerson at Clayton State University.

This video shows you how to rearrange the order of your columns after you create your analytics report. There are 2 methods. Drag and drop the columns or click Edit View and resort in the Columns and Measures row.

How To Video - full screen

This example was created by Jim Rickerson at Clayton State University.

How to hide columns in a report if you don't want them to display in your finished report. You can exclude columns but leave the measures and dimensions in your report to use later.

How To Video - full screen

This example was created by Jim Rickerson at Clayton State University.

How to add dropdown prompts to tables (or graphs). This video shows two methods for adding prompts to a table and how you can easily edit the look of an existing table into a new report by adding additional measures.

How To Video - full screen

This example was created by Jim Rickerson at Clayton State University.

This video shows how to use conditional formatting to change cell colors, font and font styles as well as background colors in your analytics reports.

How To Video - full screen

This example was created by Jim Rickerson at Clayton State University.

This video shows you how add row numbers to an analytics report table using the RCOUNT(1) function.