Reports

Report template allows you to combine mutliple dashboards in one single page. In order to use the Reports template you must have at least one dashboard configured.

To establish a connection between Reports and Dashboards, it is essential to introduce a dashboard_id field into this schema. This field must be configured as a combobox, returning the schema ID of the desired dashboard. See example below.

Example

Assume we have a schema 100 and 101, both are dashboards, i.e., have respective widgets configured on the ay_dashboard_widget table. If we want to create a Reports schema you must create a field keyed dashboard_id on the ay_field table that is a combobox with the following data_source:

{
  "rs": [
    { "id": 100, "name": "Dashboard 1" },
    { "id": 101, "name": "Dashboard 2" }
  ]
}

TIP

You could also use the SQL function of the combobox to return the id of the schema with a query directly to ay_schema.

In this case when you select the "Dashboard 1" from the combobox it will show the Dashboard 1 configured field and respective widgets, below the dashboard_id field.

In other words, see the Reports template as kind of an "iframe" to embed several dashboards into the same page. This means that you can configure a Dashboard like normal and then embed multiple dashboards on the same page.