# Explorer

<figure><img src="https://1875572357-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzP7hFWzU2Jj7xMbv2nyp%2Fuploads%2Fgit-blob-73116af64c82bde37430c63bc54025ac13c16b02%2Fexplorer.png?alt=media" alt=""><figcaption></figcaption></figure>

Explorer allows you to perform common data transformations via a graphical user interface while viewing the data. Explorer can be used on the execution results of the SQL Block or Charts in notebook and report.

## Key Features

* Spreadsheet-like UI and Drag-and-drop UI:
  * Sort, filter, and select values from column headers just as in a spreadsheet.
  * Select fields, apply filters, and sort data using drag-and-drop.
* Aggregation:
  * Perform simple aggregations (Group by) using drag-and-drop.
* Field Statistics:
  * Check statistical information from column headers.
* Chart Recommendation:
  * Generate recommended charts based on the type and form of the operation results.

## Where Explorer is Available

Since Explorer interacts directly with the original data, it’s available only in certain contexts.

* Notebook (DocPage/GridPage)
* Report
  * When `Report type` is `Interactive report`, and `Enable explorer` is selected in the Options
* Signed Embed
  * When `Enable explorer` is selected in the Options

Please refer to this section for further details.

{% content-ref url="../sharing/sharing-overview" %}
[sharing-overview](https://docs.codatum.com/sharing/sharing-overview)
{% endcontent-ref %}

## In-Memory Processing

* In Explorer, if the target data is within 1000 rows and no custom SQL is used, the in-memory processing processes data on the user's browser without issuing a new query.
* This processing can be disabled by checking the `Disable in-memory processing` checkbox.