The Weighted List Viewer widget combines the data visualization techniques of thresholds and graphical weighting into a single visualization. This enables the analyst to assess the performance of a group of items.
Thresholds in the widget highlight rows based on the value of the first metric on the widget template. Specifically, rows are highlighted according to the range of values from the first metric on the widget template’s columns. The rows are also ordered automatically so that metrics that are performing well are at the top and metrics that are performing poorly are at the bottom. A stacked bar chart is included next to the grid; it indicates the relative contribution, or weight, of each row.
To create a Weighted List Viewer widget
Add the widget to a document in Web
Open the document in Design or Editable Mode.
From the Insert menu, point to Widgets, and then select Weighted List Viewer.
Click the location on your document, other than in the Detail section, in which to place the widget. The widget template, which looks like a standard grid container, is displayed. A small icon is displayed at the bottom right of the widget template, identifying the type of widget you added to the document.
If desired, resize the widget by clicking and dragging its handles.
Add objects to the widget template
From the Dataset Objects panel on the left, select attributes and metrics, and drag them on top of the widget, as described below.
Place at least one attribute on the widget template's rows. The attribute’s elements are displayed in the grid rows of the widget. For example, if you place the Region attribute on the rows, each region is listed in the grid in the widget, with corresponding metric values on the right and a contribution chart on the left.
Place two metrics on the widget template's columns. The metric data and corresponding colors displayed in the widget reflect the performance of different elements.
The first metric on the columns is the threshold metric. This metric is used to set the color of the rows. These colors are displayed in the grid on the right side of the widget.
The second metric on the columns is the weighting metric that determines the percent-to-total value for each business attribute. It is used to set the relative size of each section of the contribution chart on the left side of the widget.
Additional metrics are displayed in the grid, but do not have any effect on the threshold colors or contribution chart on the left side of the widget.
View the widget in Flash Mode
To view and interact with the widget, switch to Flash Mode by selecting Flash Mode from the View menu.
Note: If Flash Mode is not available in the View menu, you must make Flash Mode available for this document.
Modify the widget
In Flash Mode, right-click the widget and select Properties. The Weighted List Viewer dialog box opens. These are the options:
Band 1: Select a color from the palette to represent the highest value in the widget.
Band 2: Select a color from the palette to represent the middle value in the widget.
Band 3: Select a color from the palette to represent the lowest value in the widget.
Use only two bands:
Graph gridlines:
Glass effect:
Inherit grid formatting: This option allows you to select whether the widget values -- the percentage or currency, for example -- display in the same format as they do in the grid from which they were added to the widget.
Click OK to save your changes and close the dialog box.
To use the widget as a selector
In Design or Editable Mode, do one of the following:
Right-click the attribute, custom group, or consolidation in the Grid/Graph to use as the selector, and choose Edit Selector. The Configure Selector dialog box opens.
Right-click the Metrics column in the Grid/Graph, and choose Edit Selector. The Configure Selector dialog box opens.
Select the target Grid/Graph or panel stack in the list of available targets on the left. Click > to add it to the list of selected targets on the right. You can select multiple targets.
The attribute, custom group, or consolidation you selected in the Grid/Graph is the source, and the selected Grid/Graph is the target. The Action Type of the selector is set the Select Element.
To ensure that the user can select more than one element in the widget, select the Show option for All check box.
To ensure that the element displayed in the selector changes if an element is chosen in another selector, select Allow selection to be updated by other selectors.
Click OK to apply the changes and return to the document.
Related topics: