A report in Cluvio is a SQL query together with a visualization of its results in a chart. Reports are placed on dashboards for viewing and edited in the report editor. This page gives an outline of the main components of a report.
Report Query
The report query defines how the report data is obtained from a data source and is entered into the SQL editor:
Optionally, an R script can be used to post-process the report data before it is returned to the client. The SQL query itself is executed against your data source, whereas the optional R script is executed within Cluvio's dedicated R execution environment, with each execution isolated from any other.
Report Data
The results of executing the SQL (and optionally the post-processing via R) are tabular report data:
This raw tabular data is available at any time for download via the "Download CSV" option of the Report drop-down menu on a dashboard, or from the results section in the query editor. The report data are temporarily cached, so that dashboards load quickly and the load on your database is reduced. Unless the user specifically asks for the latest data, e.g. via a Refresh action on dashboard or report, the most recently cached data is shown.
Report Visualization
The report visualization determines how the report data is presented to the user in the form of a chart. The available chart types are shown in the report editor, right below the SQL editor:
Each particular chart has its own configuration whereby you need to specify how the result data maps onto the chart.