Tile

Dashboard component type tile is created in a similar way as other components:

1. Create new component and select type Tile.
2. Insert SQL statement into SQL statement section and click Apply SQL. SQL query cannot exceed 8000 charaters. If you are using complex SQL statement you can write and edit statements in SQL edtior. Right-click in the SQL statement window and select  Edit in SQL editor.
3. Select variable that you would like to use in Current value combobox. If you are using numerical values, you can also apply Unit of measurement (or currency) in unit of measurement combobox below.
4. Select background color of the element. If no color is selected, white color is set as default.
5. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data. After selecting this option, click Apply SQL.
6. Click show button to preview the element in the preview section.
7. Click Post button  to save the element.