Creating Tile component
Tile component is used to represent a single value on a dashboard (e.g.: best buyer or sales value last month).
Dashboard component type Tile is created in a similar way as other components.
He selects Settings | Program | Dashboard Components.
Dashboards Components register opens.
He selects Insert record button in toolbar.
New record is created he continues by selecting component type.
By selecting Tile component type fields specific to Tile opens.
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.
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.
 |
Hint
Tile component enables the use of multiple variables in a tile element, with individual conditional formatting for each variable.
|
Select background color of the element. If no color is selected, white color is set as default.
To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data. After selecting this option, click Apply SQL.
Click show button to preview the element in the preview section.
Click Post button 
to save the element.
