Use the Chart Spotlight Properties frame which includes the optional creation of a computed item using an expression builder.
To use the Chart Spotlight Properties frame:
Use the Interactive Reporting document from the Building and Dragging Charts onto a Frame procedure.
From Sections, or the Configuration drop-down list found in Dashboard Studio, select Chart Spotlight Properties.
From Dashboards with Charts, select an option:
All Dashboards—Sections in a dashboard with an associated vertical bar, horizontal bar, or pie chart
Configured Dashboards—Contains at least one Chart Spotlight specification
Unconfigured Dashboards—Contains no Chart Spotlight specifications
These options filter the frames that are displayed in the drop-down list. That is, only vertical bar, horizontal bar, or pie charts, without z-axis (depth) values are listed.
Select a section from the drop-down list.
For example, select State_Revenue.
Optional: To view the selected section, click .
If no section is selected, is not selectable.
Under Spotlight Configuration, select an item from Chart Section/Shape Set.
For example, select the chart from the Building and Dragging Charts onto a Frame procedure. The drop-down list displays names for charts on the selected dashboard and sets of shapes that can be colored by the spotlight feature. Shape examples include circles or rectangles that represent color indicators or points on a map, and so on. You must select the shape set name that matches the summary table name. Shape set names cannot contain spaces.
Table Section is displayed. For example, State_Color is displayed.
From Table Section, to view the table, click (next to the table text label).
The displayed table is the source for the selected chart.
If no section is selected, is not selectable.
From Labels Column, select a column that associates with the x-axis of the selected chart or one of the shapes.
For example, select State.
The remaining tools on Chart Spotlight Properties assist with defining computed items. Proceed to Defining Color Computed Items.