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. Hover over the widget and click the Do not open this widget when the app starts button to change the setting to Open this widget automatically when the app starts. (For widgets that you need to add to the app first, you can turn on this option after configuring the widget.)

1. Hover over the widget and click the Configure this widget button to open the configuration window.

   Note:

   If you need to add the widget to the app first, click a widget placeholder on the Widget tab. In the Choose Widget window that opens, select the widget and click OK.

2. Optionally, click the Change widget icon button and replace it with your own image.

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

3. In the Chart Settings section of the widget configuration window, 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 have the same geometry type.

   2. Optionally, in the Chart settings table, change the order of the layers in the widget by using the up and down arrow buttons, 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 (line chart, 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. For a bar chart, define the x-axis title for the chart.
   11. For a bar chart, define the y-axis title for the chart.
   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 want 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.

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 button to open it.
2. Search for an address in the search bar, or click a location directly on the map to perform a search.

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

   

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.