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:
In the left menu bar, click Explore.
In the top left corner of the window, select the dataset. In our example, we chose hooli_events.
In the first line of the query builder, accept the defaults: count of events.
In the second line of the query builder, accept the default: Filtered to all events.
In the third line of the query builder, accept the default: Split by none.
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.
For the Ending time, accept the default: auto.
Click GO. The query results appears in the window on the right. We received the following results for our query.