Overview

The Advanced Query Mode in the Insights Analytics section empowers users to generate highly customized reports using SQL queries. Unlike the standard report builder that uses filters and visual options, Advanced Mode unlocks deeper analytical capabilities for users familiar with querying structured data.

This mode is best suited for users who want to perform more granular data analysis, calculate custom metrics, or extract specific results not supported by the default configuration interface.

Steps to Use Advanced Query in Insights

1. Click on the "Insights" section from the sidebar.
2. Select a specific application from the list.
3. Click on the three-dot menu next to the application and open "Insights Analytics".
4. Navigate to the "Reports" tab.
5. Click the "Advanced Mode" toggle button to enable advanced query capabilities.
6. On the right-hand side, click on the hamburger menu to access the advanced query panel.
7. By default, a predefined query is displayed in the query editor.
8. Click "Apply" to run the query and view the result.
9. You can also edit the query to run your own SQL.
10. Click "Reset" to restore the default query.
11. Use the "Undo" and "Redo" buttons for editing control within the query editor.

Writing SQL Queries

• The editor provides syntax highlighting and intellisense to auto-suggest fields from the events table.
• Only simplified and supported SQL syntax is allowed.
• Queries should reference the main dataset using the simplified name FROM events.