Show a count of events

 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.
   
   

   Open

   

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.
   
   

   Open

   

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.