| Table of Contents |
|---|
...
This article is intended to give an overview of the topic Dashboard.
...
The development of widgets requires knowledge of SQL, which also conforms to the standards of either MySQL or Oracle SQL or MSSQL syntax. For more information on which SQL syntax is used, please ask the contact person.
| Code Block | ||
|---|---|---|
| ||
SELECT lastname, email FROM view_identity WHERE identityType = 'user'; |
In this example, the widget provides an overview of all existing users in the system. Please refer to the Analyses page to access further examples.
...
Under the menu 'Add Widgets' the newly created widget will be shown and can be selected.
...
Layout and Arrangement
Several widgets can be added to the dashboard. The arrangement of the widgets can be performed automatically by selecting the desired layout from the menu, as shown in the preview. The layout selection will always affect the design of the dashboard currently being accessed.
...
Next, the diagram symbol/function can be used to set the x- and y-axes. If a specific type of diagram is desired, this is modified via the widget configuration settings. If an analysis is deemed invalid due to a value being too far outside the norm, this may be removed by selecting and deleting the respective group from the legend.
...
Working with Variables
The dashboard enables widgets to be displayed based on the selection of a particular variable's value. For instance, in the first example, not every user should be displayed by the widget. Rather, the user should be able to select the information to be displayed. To enable this function, the widget has to be changed as follows:
...
The new content will be adapted to reflect the system and the variable settings. The selection will look as depicted below after the widget has been saved:
...
...
Locking Variables
| Info |
|---|
If the same widget is to be used by multiple entities, e.g. several departments, a locked variable can be implemented in the widget. This ensures that end-user cannot change the variable. |
If the variable has been locked, the user is not able to change its value. For example, in the present screenshot, the value 'USER' would always be selected by default.
...
The user can then select the desired groups within the system (while holding the “Crtl” key) and grant them authorization to the dashboard.
...
Configuring Reports
If needed, the dashboard can export widgets in a report. These reports may be sent to specific users/groups in regular intervals. For this, a Word file with a table must be composed. The name of the to-be-exported widgets should be placed in the first cell.
...