Report Example

Below is an example of creating a report based on data stored in PostgreSQL. To build a report, you need to follow these steps:

1. Create a connection.
2. Create tables.
3. Use a script to add data from the connection to the tables.
4. Link the tables in the Data Model.
5. Create a dashboard.

Example:

1. Create a PostgreSQL connection and provide all the necessary details.
2. Create a table that you will use in the dashboard.
3. Create a script that will transfer data from PostgreSQL to your table. The script consists of three blocks:
   • clearing the table of previous data
   • receiving new data from the connection
   • adding new data to the table
   This script is described in details on the Script example page.
4. Similarly, create a second table and use a new script to fill it in with data. Link the tables in the Data Model. You can also set global indicators for the workspace in the Data Model.
5. Now you can create a report based on the data from PostgreSQL. More information about creating a dashboard and adding components is provided in the corresponding sections of the documentation.