The “Difference” calculation can be used to compute the difference between measure values: Calculate along – specifies a window and direction used to calculate differences; Difference from – select value Previous Next First Last Percentage Difference – show the percentage In the table below, we can see an absolute value of the difference between the […]

A calculation is used to compute a percentage of the total for the specified measure: Percent of total by – specifies a window and direction used to apply a Percent of Total Below we can see the table that displays the contribution of individual monthly sales to total sales:

Use the “Rank” calculation to compute rankings for the specified measure: Rank along – specifies a window and direction used to rank values; Rank type Unique Competition Dense Modified Percentile Order – ranking order Ascending Descending Below we can see the table that displays the ranking of sales for particular years in descending order:

With such choice, you can create your own expression using the necessary functions. To do this, click the “Edit in Expression Editor” button: In the window that appears, write the appropriate expression:

The «Interactive Dashboard» allows you to use any data aware dashboard item as a filter for other dashboard items: To reset filtering, use the “Clear Master Filter” button (the  icon). You can prevent specific dashboard items from being affected by “Master Filters”. To do this, use the “Ignore Master Filters” button:

The “Dashboard Title” is located at the top of the dashboard surface. It can contain text or image content: You can change title settings by clicking the “Title” button: This dialog allows you to specify the following options: Visible – specifies whether or not the dashboard title is visible; Show Master Filter state – specifies […]

The title of the dashboard element is located at the top of the dashboard and contains the following information: To edit the title of the dashboard element, select the “Edit names”  item in the context menu of the element:

The “Dashboard Designer” provides the capability to arrange and resize dashboard items and groups in various ways, using simple drag-and-drop operations: You can change the position of a dashboard item by using drag-and-drop: By default, dashboard elements automatically stretch or shrink the dashboard horizontally and vertically to fit the available screen space. You can customize […]

In the «Interactive Dashboard» it is possible to undo and redo the actions performed on the dashboard. To undo/redo the last action, use the following buttons: To undo/redo several actions at once, click the arrow next to “Undo” / “Redo” button and select the actions in the list that you want to undo/redo:

The option “Automatic” is available on the toolbar of the «Interactive Dashboard»: If this option is enabled, then all changes to the page structure will immediately display updated data. If this option is disabled, you can first modify the page as you like, and then click the button on the Button toolbar to send a […]