The Explore tool provides a dynamic data console for running new or ad hoc queries. Use it to build a suite of dashboards for your common, recurring queries or as a starting place for investigations.
Accessing near-real time, log-level data, the Explorer tool allows you to filter, group, and measure data while leveraging more than 100 dimensions.
Convert the results into a visualization that can be saved to a dashboard, downloaded, shared with others, and more.
The Explore window is accessed from the dropdown within DRE.
Alternatively, you can launch the Explore window directly from within a dashboard. Investigate a specific data set in a dashboard, then click Explore from Here.
The Fields panel displays the fields available within each log. Fields are comprised of:
- Dimensions (specific log fields, such as counts, sums, avg, etc)
- Measures (aggregates based on the logs)
You can use the search field or scroll through the list to find the desired dimension or measure. The explore window has four main components:
Dimensions and Measures are grouped together into similar buckets.
You can also create custom dimensions, custom measures, and table calculations.
You can use fields as columns, pivoted rows, or filters.
Additionally, you can select a column to show up in the results by clicking the field name. Once selected, the field name will be highlighted.
Hovering over a field allows you to select if for Pivot or as a Filter.
View the filters that are currently expected in the report and edit the operators, leveraging common operators (=,<>,in,not null ect).
Add, duplicate, or remove filters.
Additionally, create a custom filter using more complex search logic.
Expand the Visualization panel to view a variety of data graphics based on the data shown in the Results table.
You can select from various visualization types like table view, histogram, pie chart, line chart, or single number displays.
NOTE: Each visualization requires results in a specific format. If the search result data is not in the proper format, then the visualization will not load. Rather, it shows the correct format needed to load the visualization. For example, ...
Once you’ve selected the correct visualization, edit the visualization options to tailor labels, axis, color, and more.
Once you have configured the fields, click Run to initiate the search. The Results Table displays the first 500 rows of results, with the option to raise or lower the row limit.
Reorder the columns by dragging or dropping them. You can reorder the results by clicking on the column header.
Additionally, view the raw SQL query used to pull the report data.