In this article we'll explore the functions of query rows, the core components of an Indicative analysis.
Rows in the Query Builder
Query Rows represent user actions. A row may contain contain any combination of events, event properties and people properties. Rows in the query builder are numbered for easy identification in analysis results.
Create a Query Row
Every row begins with an initial event. To add an event to a query builder, you can:
- Drag and Drop into the Chart
- Drag and Drop into the Query Builder
- Double Click on an Event
Once an event is added, additional clauses and filters may be added to it:
- Understand Breakouts with "By" Clauses
- Understand Filters With "Where" Clauses
- Modify Filters With "And/Or" Clauses
Label a Query Row
Each query row may have a custom label added to it. This allows you to organize your analysis, improve readability, and ensure that data points in analysis results are appropriately labeled. These labels remain a part of the query when saved as a Bookmark, Dashboard, or shared via URL.
Collapse a Query Row
To collapse a query row, click on the minus sign icon. It is located on the lefthand side of the query row. Collapsing a query row does not affect the analysis, it only reduces the size of the row in the query builder. To expand a collapsed row, click the plus icon.
Save a Query Row as a Custom Event
Some query rows may be saved as custom events. Query rows may be saved as custom events if they consist of a single event and/or contain one or more "Where" clauses. Use custom events to save query rows that you create frequently.
To be saved as a custom event, a row:
- Must contain 1 event, and no "For" clauses
- May contain an unlimited number or "Where" clauses
- Must not contain "By" clauses
Once saved, the new event will appear in the Data Panel.
Duplicate a Query Row
When creating variations of an existing row, "Duplicate Row" in the Query Row Menu enables you to easily clone rows for modification.
Hide a Query Row
Hiding a query row excludes it from analysis results, but does not delete it. This can be useful for viewing analysis components individually, or tentatively excluding rows as you progress through an analysis.
There are two ways to hide a query row:
- Click the icon with the query row number at the far left end of the row.
- Open the Query Row Menu and click "Hide Row"
Delete a Query Row
Deleting a query row will permanently remove it from the query. There are two ways to delete a query row:
- Click the "x" in the initial event in the query row.
- Open the Query Row Menu and click "Delete Row"