Configuring a dimension field

After dragging a field to the area that corresponds to the dimension fields (A) (Columns, Rows, X axis, Y axis, Axis, and Slice label), it is possible to apply specific configurations to it.

To do that, click on the desired field (B). At this point, a side panel will be displayed, possibly containing the following fields:

▪Name: Edit this option to change the name of the field displayed in the vision.

▪Function(1): Edit this field to change the way the values of the field are aggregated: year, quarter, month, month/year, week, week of the month, day, hour, minute, or second.

▪Format: Click on this field to define the format in which the values of the field will be displayed. On the screen that will be opened, select the desired option and perform the additional configurations, if any:

oNumber: The values of the field will be numbers. On the fields that will be displayed, select the regional option that will be applied, enter the number of decimal digits, the prefix or suffix, and select the value display unit. By selecting a unit option, the suffix will be defined accordingly.

oCurrency: The values of the field will be monetary. On the fields that will be displayed, select the regional option that will be applied and enter the number of decimal digits. The prefix will be filled out with the currency of the selected regional option. The suffix will be filled out by the system if a display unit is selected.

oDate: The values of the field will be dates. On the fields that will be displayed, select the regional option that will be applied. The Mask field will be filled out according to the selected regional option, but it is possible to edit it. View examples of formats that may be used by clicking on the Templates option.

oTime: The values of the field will be times. On the fields that will be displayed, select the regional option that will be applied. The Mask field will be filled out according to the selected regional option, but it is possible to edit it. View examples of formats that may be used by clicking on the Templates option.

oDate and time: The values of the field will be dates + times. On the fields that will be displayed, select the regional option that will be applied. The Mask field will be filled out according to the selected regional option, but it is possible to edit it. View examples of formats that may be used by clicking on the Templates option.

oDuration: This option will only be available for numeric values converted to milliseconds.

▪View: Check the Hide option for the column not to be displayed in the table. Thus, it is possible, for example, to sort the table by a hidden field, to apply conditional formatting using a hidden column, and more.

1 - Available only for fields of the "Date" type.

2 - Available only for fields of the "Column" area when the "Table" or "Pivot table" options are defined.