Let us sort the table obtained earlier in the decreasing order of the “Order Count” measure. For this, click in the right corner of the table next to an icon: The column with the Order Count measure is sorted in a descending order: Having clicked again, we get the opposite result (an increase of the […]

Formatting Numeric Values Formatting Date-Time Values Currency Formatting Specifics

You can change the data format. This functionality is available on the “Dashboard Designer toolbar”: To specify a format for numeric values, select “Format” from the data item menu: This invokes the “Numeric Format” window: Types of formats can be as follows: Other format settings are in effect for only specific format types: Unit – […]

For date and time values, this functionality has the following parameters:

The «Interactive dashboard» allows you to specify a currency format at two levels: for the entire dashboard and for individual data items: Data Item Currency – to specify which currency to use for a particular data item, select “Format” from the data item menu: In the “Numeric Format” dialog, select “Currency” in the “Format type” […]

The parameter is a dashboard element that allows to dynamically influence the “Expression” highlight rule. In order to create a parameter, click the toolbar icon: The following window opens: To add the parameter, click the «Add» button. The following parameters are displayed in the window: Visible – specifies whether or not the parameter editor is […]

Each dashboard element in the “Data Items” field contains an additional field – “Hidden Data Items”: Elements of this field can be used as a context. Let us consider it on an example of one of the previous tables: We display the 7 best values of the “Order Count” measure for each product category only […]

In the interactive dashboard, the following aggregate functions are available: Count – returns the number of values Count Distinct – returns the number of distinct values Sum – returns the sum of all values Min – returns the minimum value across all records Max – returns the maximum value across all records Average – Returns […]

The «Interactive Dashboard» allows to add the following calculated elements based on the ready-made measures: You can create your own computational element: As a result, “Customize Calculation” form appears:

The “Running Total” calculation can be used to compute a cumulative total for the specified measure: Running along – the direction that is used to calculate running totals; Summary function – specifies a summary function used to apply calculation In the table below, we can see sub-total sales for all months: