Table
One of the dashboard components is also Table. It is used to show data in a table view.
Dashboard components can be accessed from the menu Settings | Program | Dashboard components.
The toolbar is found on each PANTHEON form at the top of the program window.
2.
In the header we select basic information of the Dashboard components.
This panel is used for editting the setting of the table dashboard component.
| Name |
Insert the name of the component. This name is also visible on the dashboard. |
|
(preview screen)
|
Preview of component as it will be visible on the dashboard. |
| Description |
Detailed description of the component as it will be visible on the dashboard.
|
| Filter |
A combobox, where filter variables used as filter are selected. The Filter combobox will also be visible on the dashboard.
|
| Use "Total" |
A checkbox that determines if you want to use the summary as a total value in filter or just for individual values.
|
| Rounding |
Determines the number of decimal places for numerical variables. |
| Prefetch data |
A checkbox used to define whether you want to read data for the element on the fly of stored from the table. |
| Define variable properties |
A checkbox that opens an additional grid where properties for individual variable are applied. If not selected, the grid is not visible and the rounding option for the whole component is hidden. |
| Apply SQL |
A button used to apply SQL statement. |
| Show |
A button used to preview the element in the preview screen. |
This panel is visible only if Define variable properties checkbox is selected. It enables the user to define properties of the individual variable.
| Variable |
Name of the variable from the SQL statement. |
| Conditional formating |
A checkbox to activate conditional formatting. If the checkbox is selected, values in the specified column (variable) will be colored green or red. It only applies to numerical variables.
|
| Threshold |
A numerical threshold for conditional formatting. By default, it enables 3 options:
- cells with values, higher than the threshold, are colored green,
- cells with values, lower than the threshold, are colored red,
- cells with values, same than the threshold, are not colored.
|
| Inversly |
A checkbox that inverses conditional formatting. Higher values are colored red and lower values green.
|
| Format |
Enables determining the number format and is applicable only for numerical variables. It has 3 options:
- Percentage writes number as percentage and adds % sign to value,
- Number writes number as number with separators,
- Money writes number as currency and adds default currency sign to value.
|
| Decimal places |
Used to determine the decimal places for the individual variable. |
 |
If you change the SQL statement on the existing element ad you skip clicking button Apply SQL, the following message will appear.
By confirming this message, data will be automatically reloaded as if you would click Apply SQL.
|