Title

This title is displayed in the widget's upper left corner. This does NOT identify the widget (that is defined in the "Widget Name" field).

There is a default suggestion ("My title") but we recommend a widget title related to the displayed data/values.

Define/edit the widget's title. See Details on the Widget's "Colors" pop-up window.

Data Source

Data Source

This field is NOT editable - it informs you of the type of master data you can access/display in this widget.

In this case, the master data focuses on operator data (ex: operator name, log in ID, language, etc.).

The Data Table widget is the ONLY widget that displays "master data" (= specific information collected/provided by the MCL-Mobility Platform).

Colors

Widget Background

The color defined for the widget's background.

Maintain or choose a different color - click the corresponding box to open a "Colors" pop-up window and define the new color. See Details on the Widget's "Colors" pop-up window.

Widget Title

The color defined for the widget's title, meaning, what you entered in the "Title" field.

Maintain or define another color - click the corresponding box to open a "Colors" pop-up window and define the new color. See See Details on the Widget's "Colors" pop-up window.

Table Header Background

The color defined for the background of the widget's table header.

Maintain or click the corresponding box to open a "Colors" pop-up window and choose a different color. See Details on the Widget's "Colors" pop-up window.

Table Header Text

The color defined for the text in the widget's table header.

To choose a different color, click the box to open the corresponding "Colors" pop-up window and define the new color. See Details on the Widget's "Colors" pop-up window.

Series Text

The default color for the values displayed by the widget's series (represented as text/number or the progress bar's filled in space).

Maintain or choose a different color - click the corresponding box to open a "Colors" pop-up window and define the new color. See Details on the Widget's "Colors" pop-up window.

Filters

Period

The time resolution for the data that is displayed in the selected widget which can be aggregated/grouped by "Hour", "Day (UTC)", "Day (Local)", "Week (Day (UTC))", "Week (Day (Local))" or "Month".

In addition to these default time frames, the drop-down may also include time periods from a Time Period profile (= a profile you can create with specific time periods representing specific working hours/shifts so the data sent by your devices can be aggregated according to those working hours/shifts). See Profiles.

If you have a Time Period profile in mind and its time periods are NOT listed here, go to the "Site Details" sub-module, open the "Time Period" tab and check which profile is defined for the site and edit it, if necessary.

The time resolution can also be set to "Auto".

The "Auto" option ensures that the data table's displayed data is aggregated/grouped according to the dashboard's own time resolution (which is set with the use of the related resolution drop-drown in the upper right corner).

The defining of a specific resolution for the widget means that the displayed values will NOT be affected by the dashboard's resolution. For instance, if you have a widget with a "Day (Local)" resolution and you set the dashboard's resolution, in the related drop-drown (in the upper right corner) to "Month", that widget will NOT change its values, it will continue to show values aggregated/grouped by "Day (Local)". ONLY the widgets with an "Auto" defined period will refresh their values/adopt the newly defined resolution.

Select the intended time period from the drop-down.

Hide empty rows

If this option is checked, the data table's display will be affected - any currently empty rows (without data) will NOT be displayed.

If this option is unchecked, the table will display all the rows even if a row is empty. Ex: In a data table that handles operators, all the operators will be shown, even the ones without data in any of the series.

Check/uncheck this option, as required.

Series

The data to display in this widget is grouped into series - each table column represents a series.

The corresponding internal reference for each series is "#S <number>" (ex: "#S1") - it is attributed by the system and CANNOT be edited. It can be used, for instance, in formulas, when you want to identify a series. Ex: A formula defined in a series with a "Static/Formula" data source - "=#S7-100".

A Data Table can accommodate up to 20 series.

Use the attached  buttons to add, duplicate or delete series:

•Click to add more series (maximum of 20 series per widget).

▪The default name suggestion for each series is "My Series <number>" (ex: "My Series 1") but we recommend defining a name that relates to the value it refers to.

▪When you add a series, the newly added series comes to focus in this box.

▪Fill in the related options to define its properties (data source, resolution, color, etc.).

•Click to duplicate the selected series.

▪The duplicate's name will be the name of the original plus "_copy" - the duplicate becomes the selected series in this box.

▪Rename the duplicate so it illustrates the value it will represent and fill in/review the related options to define its properties (data source, resolution, color, etc.).

Do NOT forget that you can only add/duplicate up to 20 series.

•Click to delete the selected series.

▪This option is ONLY enabled once you have more than one series (it is NOT possible to delete all the series of a widget).

The existing series are organized into a list. If required, use the buttons to reposition the selected series above or below another series. The or signs will be active/inactive depending on the selected series' current position (ex: if the selected series is in the first position, only the will be active).

If required, use the button to hide the selected series and corresponding legend:

•Click to make this caption invisible in the widget's display - this button will be replaced with ;

•Click to turn the caption visible in the widget's display again - this button will return to .

If you want to edit a series, make sure it is selected in the drop-down before proceeding with your review/edition. The other options/values in the "Data" child tab always relate to the selected series in this drop-down.

Col Name

Each series is represented as a table column.

Enter/edit the column's name, as required.

If you do not define a column name, the widget will display the name of the corresponding series (defined in the "Series" option).

Series Value

Data Source

This field references the source of the data to be represented by the currently selected series (in the "Series" option).

This particular widget allows for 4 data source types:

"Master Data"

This data source is ONLY available for Data Table widgets. It refers to specific operator related data that is provided by MCL-Mobility Platform (ex: operator name, ID, when the operator logs in/logs out etc.). Selecting this source type activates the corresponding drop-down:

Since this information is always aggregated by a specific entity such as "operator name", "operator ID", the operator's "last name", etc., the account (specifically, its sites) MUST include, at least, one operator profile.

"Counter"

A counter is an MCL-Mobility Platform entity that aggregates specific data (statistic results of processed metric values that have been sent by MCL applications/paired devices).

See Counters. Having this data source means the series presents a specific value, from a specific counter. Selecting this data source activates the following options:

"Static/Formula"

This data source allows you to enter a numeric value directly OR  use a mathematical formula to have its result represented by the selected series.

The following option becomes available when you select this source type:

"Configurable Value"

This data source refers to a value that has been configured for a specific purpose, as a sort of KPI (Key Performance Indicator). The series shows that value.

The following option becomes available when you select this source type:

The "Value" drop-down is ONLY available if there are already configured values for the current dashboard. If you have a button, instead, it means you must create "configurable values" so you can apply them to this widget series.

As an alternative, access the "Dashboard's Configurable Values" pop-up window by clicking the button, available in the header of the dashboard's details page.

Period

This option is NOT available if the selected data source is "Master Data".

Refers to the time resolution for the data of the current series, meaning, it defines how the data is aggregated/grouped - "Hour", "Day (UTC)", "Day (Local)", "Week (Day (UTC))", "Week (Day (Local))" or "Month".

Selecting the "Auto" option ensures that each series's displayed data is aggregated/grouped according to the resolution defined for the widget and for the dashboard. In other words, when running the widget, the series with a "Period: Auto" setting will have its data aggregated/grouped according to the resolution in the widget (in the "Properties" tab) and, ultimately, to what you select for the dashboard (using the drop-down located on the dashboard's upper right corner).

In addition to these default time frames and "Auto", the drop-down may also include time periods from a Time Period profile (= a profile you can create with specific time periods representing specific working hours/shifts so the data sent by your devices can be aggregated according to those working hours/shifts). See Profiles.

If you have a Time Period profile in mind and its time periods are NOT listed here, go to the "Site Details" sub-module, open the "Time Period" tab and check which profile is defined for the site and edit it, if necessary.

The defining of a specific resolution for the widget means that the displayed values will NOT be affected by the dashboard's resolution. For instance, if you have a widget with a "Day (Local)" resolution and you set the dashboard's resolution, in the related drop-drown (in the upper right corner) to "Month", that widget will NOT change its values, it will continue to show values aggregated/grouped by "Day (Local)". ONLY the widgets with an "Auto" defined period will refresh their values/adopt the newly defined resolution.

Select the intended time period from the drop-down.

Styles

Column Width

Refers the column width in pixels.

Enter the number of pixels for the width of the column.

If you do NOT enter any number, the default option is "auto" - the column width adapts to the widget's size/displayed value.

Display Mode

There are several display modes that can be applied to the value displayed by the selected series: "Textual", "Number", "Number (decimals)" or "Progress Bar".

Selecting a display mode affects the options that follow - the tab will adapt its available options to the selected display mode.

The "Textual", "Number" and "Number (decimals)" display modes have the same related options. The "Progress Bar" display mode enables its own options.

•Textual/Number/Number (decimals)

•Progress Bar

This display mode activates the "Colors" section.

"Textual" Example

"Progress Bar" Example

Colors

Chart Area

Only available if the value is displayed as a progress bar - it represents the empty space of a progress bar.

To choose another color, click the box to open a "Colors" pop-up window and define a new one. See Details on the Widget's "Colors" pop-up window.

Series Bar

Only available if the value is displayed as a progress bar - it is the color of the space that represents the value.

To define a different color, click the box to open a "Colors" pop-up window and choose it. See Details on the Widget's "Colors" pop-up window.

Series Bar Conditional Color Options

If required, you can customize the color of the area that represents the value in the progress bar further, depending on the currently displayed value.

Click the arrow to the right of the "Series Bar" option to access these advanced options:

You can add up to 3 value conditions to the defined color and attribute a color to each condition.

Example:

•The color box refers the color the value area will have when the series receives the value that fits the defined condition.

•Next to the (less than or equal to) symbols are the conditional values that trigger the different colors for the value areas. This conditional value can be static (a number) or dynamic - it can refer to another series' value, in which case, the corresponding field will be filled in with the intended series' internal reference (ex: "#2").

Check the following value condition examples:

.....