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:

The “Moving calculation” uses neighboring values to calculate a total: Moving along – specifies a window and direction used to apply a calculation; Summary function – specifies a summary function used to apply Start/End offset – initial and final offsets from the current value in process: In the table below, we can see the moving […]

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 – 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: