Creating Charts for Reporting

Any chart can be added and adjusted from the Reporting section of Single Connect:

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

Once the user clicks on the Visualize button, it is possible to select different visualization types from the Chart Type section, as well as the parameters that user needs to add or remove.

Example:

Since select * from t_device query has been executed and the 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:

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