Gauges in reports
Gauges are one-dimensional data regions, which can display a single value in your dataset. A gauge can be used as a KPI, in the table or the matrix cells to indicate single values. This recipe will show you how a gauge can be added to a matrix cell for indicating the average price.
Getting ready
Complete a report design as specified in the Create a multicolumn matrix report recipe. The report design must appear as the following screenshot shows:
How to do it…
Open the precision design created in the matrix report recipe.
Select the ItemGroupId field, right-click and select Insert Column | Inside group - Left
In the newly created column, drag the gauge control from the report items in the toolbox. Select radial and choose the design highlighted in the screenshot:
Stretch the box so that it allows you to resize the gauge control. Notice that the gauge control increases as the box expands. Stretch it to a visible limit.
Double click on the gauge control and on the Drop data fields...
