Creating Charts for Reporting

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

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

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.

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.

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:

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