Creating an Advanced Widget

You can create advanced widgets that enable you to select as many attributes and measurements to display in a chart or table as you want to, resulting in a multi-dimensional view of the data. Depending on whether you drag items into the Rows or Columns areas, the chart or table will pivot, displaying the results differently. The Spatial Attributes category appears only when you run a Geospatial Analysis with Enable Dynamic Results selected.

The example used in this topic uses the results of a Geospatial Analysis that was run using the following Event Accumulation configuration settings:

•       Accumulate Values by: AIR Event Footprints > World Scenarios > RDS Japan Earthquake (step 2, Configure)

•       Values to Analyze: Exposed Ground Up, Exposed Gross, Exposed Net of Pre-CAT (step 3, Modify Settings and Reinsurance)

•       Enable Dynamic Results: Selected (step 3)

To filter results within PGA bands by policy ID with several measurements, such as exposed limits:

1.     Open the analysis results.

2.     In the Map Tools pane, select Map Layers > Active Layers > RDS Japan Earthquake > ... (ellipsis). > Zoom to layer.

3.     Right-click on the map and then select Advanced Chart/Table from the shortcut menu. An empty Data Chart and its associated Data Selector appear. Leave the default widget mode (Chart) and leave the Defer Update check box selected.

To build the widget, you will drag items from the categories area at the top of the Data Selector to one of four areas in the Drag fields between areas below section. Notice that each area is labeled in light gray: Filters, Columns, Rows, and Measures.

4.     Expand the Exposure Accumulators category and drag Accumulator Name to the Filters area.

5.     Expand the Spatial Attributes category and drag RDSJapan_Earthquake_Pga Band to the Columns area.

6.     Select Table as the widget mode and then clear the Defer Update check box.

Touchstone updates the title bar of the widget and displays the total replacement value for the RDS Japan Earthquake. Widening the columns makes it easier to view the data.

7.     In the new table, in the Total Replacement Value Sum column, click the Expand (+) icon next to All to view the total replacement values for each PGA band.

The unlabeled column reflects the TRV for all exposures that do not fall within the PGA bands. The All Total column summarizes the TRV for the entire exposure view, as shown in the Analysis Summary.

8.     In the table's Data Selector, expand the Exposure Attributes category and drag Policy ID to the Rows area. Then expand the rows in the first column in the table, which contains the policy IDs.

You can now view the PGA bands by policy ID.

9.     In the table's Data Selector, expand the Exposure Concentration Values category and drag Exposed Gross to the Measures area.

The table will include, for each policy that generates a loss, the exposed gross sum for each PGA band. You may need to widen the table and scroll horizontally to see the exposed gross values that have been added to the far right of the table.

10.  To filter the table data and see the results in the Analysis Summary and on the map, click an item, such as a policy ID in a table row or in a bar (on a chart). ExampleIn the example used in this topic, selecting policy ID "10", which has 8 locations, changes the Risk Count Sum to 8, and changes the TRV Sum to the TRV for the 8 locations. The map now shows those locations.