Creating Charts for Reporting

any chart can be added and adjusted from the reporting section of single connect 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 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 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