Control variables
Control variables (or dashboard variables) allow you to dynamically modify the information displayed by the dashboard widgets.
More precisely, they offer the possibility to drive any axis defined in the KPIs by associating them with the dashboard variables.
Thus, it is possible to filter all graphs on a value.
The control variables are only useful for the configuration of KPI widgets.
Add/create control variables
The driving variables are on the top of your dashboard.
When you create or edit a dashboard, you can add control variables that will be used to display information related to its values.
1️⃣ Transforms a TDB into a Template.
2️⃣ Allows the user to whom the TDB is shared, to select values that were not assigned to him when configuring the template and thus, to override the restriction imposed on him.
3️⃣ Determines a value that will be pre-selected when the TDB is displayed.
Adding and linking widget variables
While creating or editing a “KPI” widget, you can add widget variables and link them to a control variable.
1️⃣ The axis of the KPI that will be associated
2️⃣ Used to determine whether the axis will be associated with a TDB variable (dynamic) or in a fixed way.
3️⃣ The TDB variable that will be associated to the KPI axis
The dashboard variable must point to values present in the KPI axis during configuration, otherwise the display will not be shown.
By selecting “Suppliers TDB”, we indicate that the KPI axis named “Suppliers” will display the data related to the selected value.
Associating several control variables with widget variables can also be used to manipulate “multi-axis” widgets.
Setting up a Dashboard template
A template is a TDB “common structure” that is shared by several users. However, the information visible in the TDB “template” is different, as it varies according to the shares and the associated control variables.
The values of the control variables will be set according to the shared users/groups, once the template has been validated.
This is useful when you want to share a TDB by limiting/restricting the data that will be accessible/visible to users/groups.
They only have access to one value, because they are only part of one group. If a third person named Michel is in both the Apple and HP groups, he will be able to select one of these two values and the corresponding graphs.
Render a TDB: “template”
When creating or editing a TDB, it is possible to activate the “Template” mode.
Template mode disables the ability to make the TDB public
Share a template
When validating the creation/editing, a share configuration window appears.
This window allows you to configure which value is associated for each user/group and TDB variable.
Sometimes the number of shares and TDB variables is too large. In this case, it makes sense to use the configuration import.
Consider making your KPIs public or users/groups supervised. Otherwise they won’t have access to the data.
Import a configuration
After pressing the import configuration button, the following window opens:
You can import a CSV file or fill in the configuration directly in a text field. The content and syntax are identical for both methods.
In the case of a CSV file import, don’t hesitate to tdownload the proposed example, complete it and upload it. The advantage is that the downloaded file will summarize the configuration already done on the previous window.
Be careful, only the login or groupId must be filled in on the same line. A line must represent the association of ONLY ONE user/group with a variable value.
