A report in Cluvio is essentially a query + visualisation, placed on a dashboard grid.
Report query is the way to obtain the tabular data from the datasource, plus the optional R script that can further transform the SQL query result data into the final result data.
The SQL query is executed by your SQL database, the optional additional R script is executed within our dedicated R execution environment isolated for every execution.
The results of executing the SQL (+ optionally R) query are tabular report data. The raw tabular data is available at any time for download via the "Download CSV" function from the Report dropdown menu on a dashboard, or from the results section in the query editor. The report data are cached, so that dashboards display fast and the load on your database is reduced. Unless the user specifically asks for current results (via Refresh action on dashboard or report), the cached data, if present and current, will be displayed.
The way the report data are presented to the user is determined by the report visualisation, which is configured as part of creating/editing the report in the query editor. This step configures how the columns in the result data are interpreted, formatted and visualised as tables, numbers or charts once the report is placed on the dashboard.