FAQ content

What can I do with a Counts / Aggregate dataset?

In this article

The Counts/Aggregate dataset is the best way to record and analyze data in a tabular format. This type of dataset is ideal when you want to gather and record daily, monthly, or yearly totals for something. Unlike a Custom dataset, where records are analyzed based upon each record's timestamp, records in the Counts/Aggregate dataset area analyzed by the day, month, or year you provide. 

In other words, if you have a spreadsheet where you are tracking totals by day (such as library head counts), month (such as ILL or reference transactions), or year (such as acquisitions or expenditures), the Counts/Aggregate dataset will be a good fit.

With these datasets, you can analyze your data with the following reports:

  • Overview: datatable containing the daily/monthly/yearly totals
  • Field Aggregates: provides the count, sum, average, median, minimum, and maximum of your data
  • Charts: analyze one or more fields in a bar, stacked, or line chart
  • Distributions: provides a breakdown of your data by year, month, day of the week, and weekdays vs. weekends
  • Trends: allows you to compare data for the same time period over a number of years (e.g. compare fall semester totals for the current year against the previous 5 years)

Example chart for a Counts/Aggregate dataset