# Configure dashboards > Dataset editor (addon-reports)

## Description

<p class="callout success">The datasets used to generate the charts, which in turn generate the dashboards, will be registered on the "**Dataset editor**" screen.</p>

<p class="callout info">**SQL queries** will be used directly on the Soffid database to retrieve the data sets. If you wish to consult the structure of the Soffid database, you can consult the [internal Soffid API (Entities section)](https://download.soffid.com/doc/console/latest/uml/ "internal Soffid API").</p>

## Screen overview

[![image.png](https://bookstack.soffid.com/uploads/images/gallery/2025-09/scaled-1680-/ZiTlGPxu4vbLQRol-image.png)](https://bookstack.soffid.com/uploads/images/gallery/2025-09/ZiTlGPxu4vbLQRol-image.png)

[![image.png](https://bookstack.soffid.com/uploads/images/gallery/2025-09/scaled-1680-/SIYojkNRw9Hp1jub-image.png)](https://bookstack.soffid.com/uploads/images/gallery/2025-09/SIYojkNRw9Hp1jub-image.png)

## Related objects

- [Dashboard editor](https://bookstack.soffid.com/books/soffid-4-reference-guide/page/configure-dashboards-dashboard-editor-addon-reports "Configure dashboards > Dashboard editor (addon-reports)") : to create and manage dashboards
- [Chart editor](https://bookstack.soffid.com/books/soffid-4-reference-guide/page/configure-dashboards-chart-editor-addon-reports "Configure dashboards > Chart editor (addon-reports)") : to manage charts to be used in the dashboard editor
- [Dataset editor](https://bookstack.soffid.com/books/soffid-4-reference-guide/page/configure-dashboards-dataset-editor-addon-reports "Configure dashboards > Dataset editor (addon-reports)") : to manage datasets to be used in the chart editor
- [Dashboards](https://bookstack.soffid.com/books/soffid-4-reference-guide/page/dashboards-addon-reports "Dashboards (addon-reports)") : where the dashboards created in the dashboard editor are displayed

## Standard attributes

- **Name**: name of the dataset
- **Description**: description of the dataset
- **Target system**: use this field when the SQL query needs to be executed from an agent
- **SQL sentence**: SQL sentence to retrieve the dataset from the Soffid database
- **Refresh interval in seconds**<span class="colon">: refresh interval in seconds to refresh the database</span>
- <span class="colon">**Updated on**: date of the last update</span>
- <span class="colon">**Updated by**: user or the last update</span>

## Actions

#### Table actions

<table id="bkmrk-query-allows-to-sear-0" style="width: 96.4286%; height: 89.6355px;"><tbody><tr style="height: 29.8785px;"><td style="width: 22.5%; height: 29.8785px;">**Add new**</td><td style="width: 77.5137%; height: 29.8785px;">Allows you to create a new dataset.</td></tr><tr style="height: 29.8785px;"><td style="width: 22.5%; height: 29.8785px;">**Delete**</td><td style="width: 77.5137%; height: 29.8785px;">Allows you to delete all datasets selected with the checkbox in the first column.</td></tr><tr style="height: 29.8785px;"><td style="width: 22.5%; height: 29.8785px;">**Download CSV file**</td><td style="width: 77.5137%; height: 29.8785px;">Allows you to download a CSV file with the dataset data.</td></tr></tbody></table>

#### Dataset actions

<table id="bkmrk-apply-changes-%28disk-" style="width: 96.4286%; height: 239.028px;"><tbody><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Apply changes (disk icon)**</td><td style="width: 75.415%; height: 29.8785px;">Allows you to save the updates of the dataset.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Delete**</td><td style="width: 75.415%; height: 29.8785px;">Allows you to delete the dataset.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Expand all**</td><td style="width: 75.415%; height: 29.8785px;">Displays all the attributes of the different blocks.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Collapse all**</td><td style="width: 75.415%; height: 29.8785px;">Hide all attributes of the different blocks.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**"Types of views"**</td><td style="width: 75.415%; height: 29.8785px;">Change the view type: Classic view, Modern view, Compact design.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Refresh**</td><td style="width: 75.415%; height: 29.8785px;">Allows you to display a table with the result of the SQL sentence.</td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Undo**</td><td style="width: 75.415%; height: 29.8785px;">Allows you to quit without applying any changes. </td></tr><tr style="height: 29.8785px;"><td style="width: 24.5988%; height: 29.8785px;">**Apply changes**</td><td style="width: 75.415%; height: 29.8785px;">Allows you to save the updates of the group.</td></tr></tbody></table>