Creating Charts for Reporting
Any chart can be added and adjusted from the Reporting section of Kron PAM:
- Navigate to Dashboard > Reports > SQL Lab.
- 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.
Once the user clicks on the Explore button, a pop-up appears. From there, User can save this query as a new one or overwrite existing one.
Example: Since select * from aioc.t_user_auth_log query has been saved and following screen; there is a VISUALIZATON parameter. In this parameter Table View visualization type has been selected, Superset will show 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:
- Overwrite chart
- Save as a new chart
- Link created chart to dashboard
After saving, the desired chart can be found under the Chart section of the Reporting tab.