Related Table Charts widget

(Added at version 2.0)

The Related Table Charts widget allows you to chart (bar, pie, or polar chart) values from a related table of a feature layer.

The structure of the layers requires a relationship between a feature layer and a table and must be a one-to-many geodatabase relationship.

Configure the Related Table Charts widget

This widget can be set to open automatically when an app starts. To enable this feature, click the Open this widget automatically when the app starts button Open this widget automatically when the app starts on the widget, which turns it dark green.

  1. Hover over the widget and click the Configure this widget button Configure this widget to open the configuration properties dialog box.
  2. Optionally click the Change widget icon button and replace it with your own image.

    A file explorer window opens, allowing you to select a local image file to use as the widget icon.

  3. In the Chart Settings section of the widget configuration, specify the following options:
    1. Click Add New to add new layers to the widget.

      When prompted, define the layer to be configured in the widget and the table related to the layer that will be used to draw the charts. If you configure more than one layer, the layers are required to be the same geometry type.

    2. Optionally, in the Chart settings table, change the order of layers in the widget by using the up and down arrows, or remove a configured layer by clicking the Delete button.
    3. Define a title in the Section title field, including field name variables.
    4. Define a title in the Chart title field, including field name variables.
    5. In the Description area, provide additional information about your chart, including field name variables.
    6. For Chart type, choose the type to be displayed (bar chart, pie chart, or polar chart).
    7. For Data series field, choose a numeric field value to be charted.
    8. For Label field, choose a field for the charted values.
    9. Select a styling option for the chart:
      • Single color—All values will be the same color.
      • Color by theme—Values will use the colors from the theme.
      • Color by field value—Define a color for each value.
    10. Define the x-axis title for the bar chart (bar chart only).
    11. Define the y-axis title for the bar chart (bar chart only).
    12. Optionally click the Layout button to see an outline of what the chart will look like for each layer.
  4. To configure the Search Source Settings section, see the Search widget topic. The Related Table Charts widget follows the same configuration steps.
  5. Optionally, in the General Settings section of the widget configuration, you can specify the following options:
    1. Graphic location symbol—Select and adjust the symbol of the address or location symbol.
    2. Refresh interval—Define the interval at which you would like the charts to refresh. This should be a value between 0.1 and 1,440 minutes.
    3. Choose to enable the Set location button, which will require users to drop a pin on the map to initiate a search.
  6. Tip:

    If you configured the widget for more than one layer, you'll want to optimize the visual appeal of the map by turning off all the configured layers in the map. By doing so, you won't have overlapping symbology and blending of colors in the application.

    The first time you search for an address or click the map, you will see the first layer configured in the widget displayed in the related chart, and the corresponding layer will be turned on in the map. When you select another chart, the corresponding layer will be turned on and all other layers turned off.

Use the Related Table Charts widget

  1. Click the Related Table Charts widget icon to open it.
  2. Search for an address in the search bar or click a location directly on the map to execute a search.

    Once a location is defined, select a layer and you'll see the chart information expanded in the widget panel.

    Related table information

  3. Optionally, if other layers have been configured, select the heading of each item and see additional charts. To collapse a chart, click the expanding heading again.
  4. Hover over the bar chart or pie chart to see the exact numeric value.