A count of events query lets you count the number of events in a dataset, rapidly. This function is a basic requirement for most businesses today. This article shows you how to create a basic show count of events query.

Show a count of events

You can calculate the number of events over a set period of time in a number of ways. The following query example does not require you to build a custom event property. For information on how to build an event property, see Building an event property.

To show a count of events, do the following:
  1. In the left menu bar, click Explore. 

  2. In the top left corner of the window, select the dataset. In our example, we chose hooli_events.

  3. In the first line of the query builder, accept the defaults: count of events.

  4. In the second line of the query builder, accept the default: Filtered to all events.

  5. In the third line of the query builder, accept the default: Split by none.

  6. Specify the Starting time for the query by: choosing an option from the drop-down list, clicking the calendar icon and selecting a date from the pop-up calendar, or clicking inside the text field and entering the desired value. In our example, we entered a value of 180 days ago. For more information on how Scuba handles time intervals, see Specify time in a query.

  7. For the Ending time, accept the default: auto.

  8. Click GO. The query results appears in the window on the right. We received the following results for our query.