Flyover Views

A flyover filters the information displayed in selected Viewsheet components when the user moves the mouse over (or clicks on) particular regions of a chart, table, or crosstab. This effectively allows a Chart, Table, or Crosstab to behave as a selection element. Flyover is similar to the Data Tip View, except that the filtered components remain in their original positions (rather than following the mouse).

Walkthrough

In this example, you will create a chart that displays quantity purchased by company. When the user click a given company, the Chart will display a Gauge as a Data Tip. This Gauge will display the average quantity purchased by the individual company.

1. Create a new Viewsheet based on the sample 'US Sales' Work­sheet.

2. Drag a Gauge from the Component tree into the Viewsheet.

3. Configure the Gauge to display the average quantity purchased. Follow these steps:

a. From the 'Sales' Data Block (top of the Component tree), drag the 'Quantity Purchased' field onto the Gauge. This binds the Gauge to the Data Block.

b. Right-click the Gauge, and select 'Properties' from the context menu. This opens the 'Properties' dialog box for the Gauge.

c. Under the General tab, change the 'Name' property to “QuantityGauge”.

d. Set the following limits: 'Maximum'=200, 'Minor Increment'=10, 'Major Increment'=25.

e. Under the Data tab, select 'Count' form the 'Aggregate' menu. This will display the number of records (orders) for each company.

f. Click 'OK' to close the 'Gauge Properties' dialog box.

4. Drag a Table component onto the Viewsheet grid. Follow the steps below to configure the Table:

a. In the 'Sales' Data Block (top of the Component tree), select the following fields: 'Category', 'Company', 'Name'.

b. Drag the selected fields onto the Table component. This adds the three columns to the Table. Resize the Table as desired.

 

c. Right-click the Table, and select 'Properties' from the context menu. This opens the 'Table Properties' dialog box.

d. Under the General tab, change the 'Name' property to “CompanyTable”.

e. Under the Advanced tab, select 'Shrink to Fit'. This automatically sizes the table to the number of records displayed.

f. Press 'OK' to close the dialog box.

5. Drag a Chart element onto the Viewsheet grid.

6. Click the center of the Chart (or click the 'Edit' button at the top-right). This opens the Chart Editor. Make the following selections:

a. From the 'Dimensions' node in the Data Source panel, drag the 'Company' dimension to the 'X' field in the Data panel.

b. From the 'Measures' node in the Data Source panel, drag the 'Quantity Purchased' measure to the 'Y' field in the Data panel. This creates a chart that displays quantity purchased for each company.

c. Click the 'Edit Dimension' button, and select 'Ranking' to display only the top 10 companies. Click the 'Apply' button.

 

d. Right-click on the one of the Chart's X-axis labels, and select 'Axis Properties' from the context menu. Choose a slanted text rotation and a smaller font size to improve the axis appearance. Click 'OK'.

e. Resize the chart as desired.

 

7. Right-click the Chart, and select 'Properties' from the context menu. This opens the 'Chart Properties' dialog box.

a. Select the General tab.

b. In the 'Flyover' panel, click to select the two available components: 'CompanyTable' and 'QuantityGauge'.

 

c. (Optional) Select 'On Click Only' if you want the filtered components ('CompanyTable' and 'QuantityGauge') to update only when the user clicks on the chart. Otherwise, the components will update whenever the user hovers the mouse over the chart.

d. Click 'OK' to close the 'Chart Properties' dialog box.

Note: Data tips are not active in the Design view. Preview the Viewsheet to see them.

8. Preview the Viewsheet, and hover the mouse (or click) over different companies in the Chart. Observe that both the Table and Gauge are filtered to display only the corresponding data.

 

9. To lock the selection to a particular company (or set of companies), click on the Chart to select the desired company (or Ctrl-click to select a set of companies). This will lock the filter in place until the selection is removed.

You can use a single component in both a Data Tip View and a Flyover view. If you designate a Data Tip component for Flyover duty, the component always remains visible on the Viewsheet.

See Also

Brushing a Chart, to use Chart selections to highlight (rather than filter) other components.

<< Data Tip View © 1996-2013 InetSoft Technology Corporation (v11.4) Chart Properties: Advanced Tab >>