---
title: Creating Charts for Reporting
slug: kronpam-reference-guide-3-5-0/creating-charts-for-reporting
description: Learn how to add and customize charts in Kron PAM reporting with this user-friendly document. Discover how to run queries from the SQL editor and visualize the results in the Results section. Modify and save queries, adjust visualization types, time filte
docTags: 
createdAt: 2022-08-02T18:25:44.000Z
---

Any chart can be added and adjusted from the Reporting section of Kron PAM:

1. Navigate to **Dashboard **> **Reports** > **SQL Lab**.
2. Once the database has been selected, the user can run any desired query from the SQL editor, and then save or visualize it. Saved queries can be accessed from the Saved Queries section under the SQL Lab.

Once the user runs the query, the results collected from the database are shown in the Results section, as illustrated in the figure below.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/gSMmHrzKiyo-51cPplxPt_image.png "Running queries from SQL Editor to Create a Chart")


Once the user clicks on the **Explore** button, a pop-up appears. From there, the User can save this query as a new one or overwrite the existing one. 

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/JJaPMg4EuIEfjDC8o3ePV_image.png "When Query runs, the output has an option to click Explore")

**Example:**
Since select \* from aioc.t\_user\_auth\_log query has been saved and in the following screen; there is a VISUALIZATION parameter. In this parameter **Table View **visualization type has been selected, Superset will show the results of the selected columns in Table View. Also, the time filter can be edited, and columns can still be adjusted from the **Group By **section. The User can edit the chart name as well.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/6DCtjPKTbRjNPfotO7cxZ_image.png "Adjusting Chart Properties")

The result might change, depending on the time filter, and selected columns & functions in the Group By section. Once the user makes adjustments, he/she needs to run the query again from the **Run Query** section to see the updated result.
When adjustments are ready, and once the user clicks the** Save** button, a pop-up window providing the following options will open:

-
  Overwrite chart
-
  Save as a new chart
-
  Link created a chart for the dashboard

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/U1blycSQ0Mp_4poJCch1f_image.png "Overwrite or Save New Chart and Link to Dashboard")

After saving, the desired chart can be found under the Chart section of the Reporting tab.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/FhBbzMecmunL-3mgkGZTc_image.png "Created Charts in the Reporting section Charts tab ")