Follow

Dynamic Reporting - Explore Overview

Explore_Overview_01.png

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.

Accessing Explore

The Explore window is accessed from the dropdown within DRE. 

Explore_Overview_02.png

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.

Explore_Overview_03.png

Fields Panel

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:

Explore_Overview_04.png

Dimensions and Measures are grouped together into similar buckets.

Explore_Overview_05.pngExplore_Overview_06.png

You can also create custom dimensions, custom measures, and table calculations.

Explore_Overview_07.png

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.

Explore_Overview_08.png

Hovering over a field allows you to select if for Pivot or as a Filter. 

Filters Panel

Explore_Overview_13.png

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.

Explore_Overview_14.png

Additionally, create a custom filter using more complex search logic.

Explore_Overview_15.png

Visualization Panel

Explore_Overview_16.png

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, ...

Explore_Overview_17.png

Once you’ve selected the correct visualization, edit the visualization options to tailor labels, axis, color, and more.

Explore_Overview_18.png

Results Panel

Explore_Overview_09.png

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.

Explore_Overview_10.png

Reorder the columns by dragging or dropping them. You can reorder the results by clicking on the column header.

Explore_Overview_11.png

Additionally, view the raw SQL query used to pull the report data.

Explore_Overview_12.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments