Elements of data analysis can work with different data sources. Before starting the design of the dashboard, you should read the following chapters:
Data Sources;

Relations between data sources;
Data transformation.

 

This chapter will cover the following:

Data fields;

Data filed expression;

Adding data to an element;

Putting values manually;

Enter data manually;

Removing data from elements;

Table of Functions.

 

All data sources of dashboard elements form a virtual data table for the current dashboard. This is necessary for the interaction of the dashboard elements with each other.
 

 

 

You can view the virtual table of a dashboard by selecting the View Query command in the context menu of the dashboard header.

 

 

 

Data fields

There are fields in which data fields are indicated in the editor of the dashboard elements. Each data field has an expression which results of processing are the data values ​​for the current dashboard item. The data field expression can be a reference to a data column or a variable.

If a reference to a data column is specified, the values ​​of the data column will be the values ​​of the data field on the basis of which the current element of the dashboard will be rendered.

If a reference to a variable is specified, the value of the variable will be the value of the current data field. You should know that at this moment we support the variable of the Value is specified.

Also, you can manually specify the values ​​of the data field. To do this, enter a value or a list of values in the Expression field of the current data field. To enter values ​​manually, you should use the List() or Array() functions using the "," separator between values.

 

A function can be applied to the expression of data fields. In that case, the values of the data field will be the values processed using this function.

 

You can add a new data field using on of the ways below:

Drag and drop a data column into an item field. In this case, a new data field will be created with reference to the data column you dragged.

Select the New Field command from the context menu of the element editor.
 

In the Table element, the data fields can be of the following types:

Measure. By default, this field type applies to all numeric data types. Also, this type of data field is used if it is necessary to group the values of the current data field by the values of another data field.

Dimension. This type of field is used by default for non-numeric data types. When grouping data, the values of this data field will be a condition of grouping for the values of other data fields.

 

Changing the type of data field is carried out in the Table element editor, using the Measure and Dimension buttons:

 

 

 

Data field expression

The data fields of the element have the Expression field. In this field, you can see the expression of the current data field, and there is also a drop-down menu with a list of commands:

 

 

The command is used to create a field of the Dimension type.

The command is used to create a field of the Measure type.

The command is used to create a duplicate of the current data field.

The command calls the expression editor for the current data field.

The command is used to change the name of the current field. Also, you can select a field in the list and press the F2 key.

The command is used to delete the current field.

The command is used to remove all data fields from the current item field.

The command contains menus and submenus with a list of data sources from the report dictionary and data columns in these sources. With this command, you can select the data column for the current field.

A list of the most frequently used functions that can be applied to the expression of the current field. Depending on the type of data, this list of functions may vary.
 

 

Adding data to an element

Drag and drop the data source or columns from the dictionary to the element or its editor. In this case, data fields will be created with references to data columns.

 

 

 
Select the data field in the element editor, using the Field command, select a data column. In this case, the expression of the data field will be a reference to the selected data column.
Select the data field, call the Expression editor to create an expression for this field;
Select the data field and change the expression manually.
 

 

Putting values manually

In the elements of the dashboard, you can enter one value for the current data field or you can specify a list of values. To enter a single value, you should:

Call the item editor;

Create a new data field;

In the Expression field you should enter the value for the current data field;

In addition to this data, which entered manually.
 

 

 

To enter a list of values, you should to the following:

Call the item editor;

Create a new data field;

In the Expression field you should enter the List() or Array() function with the list of values with the "," separator.
 

 

 

Enter data manually

There is the mode of element data manual input for the following elements: Chart, Indicator, Progress, and Gauge. In this mode, each element data field is a column with cells. You can specify one value of an element in each cell. A list of entered values in various columns will form a data table for this element. The number of element data rows is not limited.

 

To go to the manual value input mode, you should click the Enter Data Manually control. After that, the grid of value input, where you should specify element data will be displayed. You can specify expressions in the cells. For example, specify a link to the - {Variable1}. In this case, the result of the expression processing will be a value for the current cell.

 

 

 

 

The commands of row control are placed in the context menu and allow you to:

Move a selected row upper or bottom;

Insert a row or rows upper or bottom than the current one;

Delete a selected row or rows from the grid of element data.

 

Pay attention to the fact that:

The cells in the grid of manual input can be selected using the Ctrl button.

The range of cells can be selected using the Shift button.

You can entirely select a column or row having clicked a column or row header;

You can select entirely the grid of manual input having clicked the upper left cell, which is located at the intersection of row and column headers.

 

To go back to the data from columns mode, you should click the Use Data Fields in the element editor.

 

Links to data columns can be specified in a dashboard element and entered manually. However, the analysis and display of data depends on the mode you select (manual or data fields) in the element editor.

 

 

Removing data from elements

Select the field in a specific field of the element editor, and click the Remove Field button (see the picture below).
 

 

 
Select the Remove Field command in the context menu of the current data field.

Select the Remove All Fields command in the context menu of the field of the dashboard element, .

 

If the manual mode is enabled you can:

Delete rows from a table. To do this, you should select the rows or cells in the rows that should be deleted and select the Delete command from the context menu of the value input grid.

Also, you should clear the content of the cells. To do this, you should select the cells that should be cleared and click the Delete key on the keyboard.
 

 

List of functions

Depending on the type of values, the list of functions used may vary. The table below contains a complete list of functions that can be applied to data fields.