Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 152 of 212

140 C H A P T E R 7 | Better reporting background of the delta value or percentage, or a directional arrow. Furthermore, you specify whether high delta values are good (green) or bad (red). Apart from these settings and the ability to resize the elements or apply a theme to your mobile report, you have no additional control over the appearance of a gauge, such as font type or font size. In addition, you can optionally define a drill-through target for any gauge. A drill-through target can be an existing mobile report to which you can pass a static value or a selected value to override default values in data sets. Alternatively, a drill-through target can be a custom URL that you can define to include parameter tokens as part of the query string. In the group of numerical gauges, shown in Figure 7-22, you can choose from the following four options: Number This gauge displays a single aggregated value from the connected data set. Delta number You must define an actual and target value for this gauge, either from two columns in the same data set or from columns in two separate data sets. The default display is the delta value. Delta indicator You configure this gauge much like the delta number gauge. It uses a green arrow indicator pointing up to indicate a good value and a red arrow indicator pointing down to indicate a bad value. The default display is the delta's percentage of the target. Number with delta This gauge is a combination of the number, delta number, and delta indicator gauges. The default delta label is Value And Percentage From Target. The background for the delta uses the range stops to display red, amber, or green. You have the option to use this color for the entire gauge rather than for the delta number only. Figure 7-22: Displaying numerical gauges in a mobile report. Note Mobile Report Publisher automatically aggregates the numerical value to display by using the Sum function. You can change this behavior by clicking the element in the Control Instances panel in the mobile report's data view. Then click the Options button in the Data Properties panel. In the dialog box that is displayed, select one of the other aggregate functions: Avg, Count, Min, Max, First, or Last. In the group of graphical gauges shown in Figure 7-23, each displays the actual value and, optionally, a delta value and percentage as described for the numerical gauges. You can specify ranges to determine how to visualize values as red, yellow, or green objects or areas on a scale. This group contains the following seven options: Radial gauge This gauge uses a pointer on a scaled arc to represent the actual value's percentage of the target value. Linear gauge This gauge uses a linear scale with a pointer to represent the actual value's percentage of the target value. Bullet graph The bullet graph is similar to the linear gauge but replaces the pointer with a progress bar superimposed on the scale and a marker to indicate the actual value as a percentage of the target value.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016