Configure Election Results

Election Results can be used to share results tabulated on election night and historical results shared after each election.

In this topic, you’ll learn how to configure the Election Results solution to meet specific needs in your organization.

Load data

The Election Results solution includes the ElectionResults feature layer, which you will use to store your tabulated election results data. The ElectionResults feature layer includes two sublayers: Voting Jurisdictions and the Election Results table. Voting Jurisdictions stores the geographic jurisdiction you’re using to visualize election results on a map (for example, County, Municipality, or Precinct). In the Election Results table, each record represents the results of a ballot measure by contest, candidate, and jurisdiction. Additionally, you can use the Contest Category field to categorize each record in the table as Elected Office or Proposal.

The following example shows the Election Results table for a two-candidate mayoral race with three precincts reporting:

ContestContest CategoryJurisdiction NameCandidatePartyNumber of Votes

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

306

Mayor (Vote for 1)

Elected Office

Precinct 2

John Doe (D)

Democratic

147

Mayor (Vote for 1)

Elected Office

Precinct 3

John Doe (D)

Democratic

350

Mayor (Vote for 1)

Elected Office

Precinct 1

Jane Smith (R)

Republican

245

Mayor (Vote for 1)

Elected Office

Precinct 2

Jane Smith (R)

Republican

153

Mayor (Vote for 1)

Elected Office

Precinct 3

Jane Smith (R)

Republican

294

Tip:

When naming fields, consider including information that will provide more context in the Election Results Dashboard app. In the previous example, the maximum number of votes was added to the Contest field ("Vote for 1"), and the party designation was added after the candidate's name in the Candidate field.

In the previous example, the candidates are symbolized in the map and chart by their traditional party color. The Party field domain also includes 10 nonpartisan options. These options can be used for any contest, including nonpartisan and primary contests, in which a candidate needs to have a unique color from other candidates in the same contest but the color is not tied to their political party. The following example shows a nonpartisan contest:

ContestContest CategoryJurisdiction NameCandidatePartyNumber of Votes

School Board (Vote for 2)

Elected Office

Precinct 1

John Doe

Nonpartisan 1

306

School Board (Vote for 2)

Elected Office

Precinct 2

John Doe

Nonpartisan 1

147

School Board (Vote for 2)

Elected Office

Precinct 3

John Doe

Nonpartisan 1

350

School Board (Vote for 2)

Elected Office

Precinct 1

Jane Smith

Nonpartisan 2

245

School Board (Vote for 2)

Elected Office

Precinct 2

Jane Smith

Nonpartisan 2

153

School Board (Vote for 2)

Elected Office

Precinct 3

Jane Smith

Nonpartisan 2

294

You can also use the Election Results table to store the results of ballot measure proposals by setting the value for the Contest Category to Proposition. Populate the Candidate field with Yes and No and leave the Party field blank. In the following example, Proposal 1 was voted on in a community with three precincts:

ContestContest CategoryJurisdiction NameCandidatePartyNumber of Votes

Proposal 1

Proposal

Precinct 1

Yes

306

Proposal 1

Proposal

Precinct 2

Yes

147

Proposal 1

Proposal

Precinct 3

Yes

350

Proposal 1

Proposal

Precinct 1

No

245

Proposal 1

Proposal

Precinct 2

No

153

Proposal 1

Proposal

Precinct 3

No

294

The Election Results solution can also be used to share results for ranked choice voting contests. Ranked Choice Voting is a system in which voters rank candidates by preference on their ballots. If no candidate meets the threshold to be declared a winner—for example, greater than 50 percent of the vote—then the candidate with the fewest first place votes is eliminated and the second choice from those ballots are added to the totals for the remaining candidates. Results are tallied again to determine if there is a winner. If not, the process is repeated until a winner is determined. Each tallying and eliminating iteration is referred to as a round. The result of each round is represented in the Election Results table.

In the following example, results for a single candidate in one precinct for five rounds are shown. The first round represents the number of first choice ballots the candidate received. The second round represents the number of first choice ballots and the additional second preference votes the candidate received after another candidate was eliminated. In Round 4, the candidate was eliminated, which is represented by 0 votes. In the final round of the contest the eliminated candidate is included, again represented by 0 votes. You would repeat this for each candidate in the contest across all the precincts.

ContestContest CategoryJurisdiction NameCandidatePartyRoundNumber of Votes

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

1

306

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

2

325

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

3

349

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

4

0

Mayor (Vote for 1)

Elected Office

Precinct 1

John Doe (D)

Democratic

5

0

Note:

When loading non-ranked voting results, leave the Round field blank.

Caution:

You can add new fields to the ElectionResults feature layer, but do not delete any fields from the Voting Jurisdictions layer or Election Results table. Deleting fields will break the ElectionResults_join view and the Election Results Dashboard app.

Load election results from a spreadsheet

You can load election results from a spreadsheet sourced from your tabulation system. The Election Results solution includes the ElectionResults.csv file, which you can use to load data into the ElectionResults feature layer.

To load election results from a spreadsheet, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the ElectionResults.csv item.
  2. From the item page, click Download.
  3. Open the CSV file and edit it with your information.
  4. Save and close the file.
  5. In your ArcGIS organization, browse to the ElectionResults feature layer.
  6. From the item page, click Update Data.
  7. Follow the steps in the Update data wizard to load your data.
  8. Tip:

    For more information about uploading data, see Manage hosted feature layers—Append data to layers.

Load voting jurisdictions from a shapefile or file geodatabase

Voting jurisdictions define the geographic jurisdiction you’re using to visualize election results on a map (for example, County, Municipality, or Precinct) and also store voter turnout and method metrics.

To load voting jurisdictions from a shapefile or file geodatabase, complete the following steps:

  1. Create a .zip file of your shapefile or file geodatabase.
  2. Verify that you are signed in to your ArcGIS organization and browse to the ElectionResults feature layer.
  3. From the item page, click Update Data.
  4. Follow the steps in the Update layer wizard to load your data.
    Note:

    The only required field is the Jurisdiction Name (jurisdictionname) field. This text field defines the unique name of the jurisdiction used in the relationship with the election results.

  5. Tip:

    For more information about uploading data, see Manage hosted feature layers—Append data to layers.

Modify political parties

The Elected Office map symbolizes the jurisdiction using the party of the candidate who received the most votes for the jurisdiction. Each candidate is also displayed in the chart using the color associated with their party. The Party field in the ElectionResults feature layer has been configured with a domain containing some of the most common political parties in the United States and 10 nonpartisan party options that can be used to uniquely identify candidates in the same contest. You can use these options to modify the list of political parties to match the parties of the candidates in your jurisdiction. The resulting list reflects the political parties that are available in the Election Results Dashboard app.

Update the field domain

Although there is only a handful of main political parties, there are dozens of smaller parties or party factions that you may need to represent in your Election Results Dashboard app.

To add, delete or modify a political party, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the ElectionResults feature layer.
  2. From the item page, click the Data tab.
  3. From the Layer drop-down list, choose Election Results.
  4. On the right, click Fields.
  5. Click Party.
  6. For List of Values (Domain), click Edit.
  7. From the editable list of party values, you can revise labels and their stored values, delete unnecessary labels, and add new ones.
  8. To revise a value, replace the existing text with new text.
  9. To delete a value, click the Delete button to the right of the value.
  10. To add a value, scroll to the bottom of the list and click Add.
  11. In the Label (displayed value) and Code (stored value) fields, type the party name.
  12. Optionally, drag a value up or down to reorder the list.
  13. Click Save.

Update the map symbology

If you have modified the political parties in the ElectionResults layer, you may need to update how the parties are symbolized on your map.

To update the map symbology, complete the following steps:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results - Elected Office web map.
  2. From the item page, click Open in Map Viewer.
  3. On the Contents (dark) toolbar, click Layers Layers to open the Layers pane, and then click the Elected Office Results layer.
  4. On the Settings (light) toolbar, click Styles Styles to open the Styles pane.
  5. Under Pick a style, click Style Options to open the Style options pane.

    Any political parties that you added in to the ElectionResults feature layer appear at the bottom of the list.

  6. Scroll to the bottom of the list and check the check box for each of the political parties that you added.
  7. Click Move to group and choose Untitled group.

    The political parties are added to the layer and appear in the legend.

    You can also remove parties from appearing in the legend.

  8. In the Style options pane, dragany political parties that you want to remove to the Other section.
  9. Click the color symbol next to each new party and assign a custom color.
  10. At the bottom of the Style options pane, click Done.
  11. On the Contents (dark) toolbar, click Save and open Save and open and click Save Save.

Update the dashboard chart

If you have added political parties to the ElectionResults layer and the Election Results - Elected Office web map, you must also update the dashboard chart.

To update the dashboard chart, complete the following steps:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results Dashboard.
  2. From the item page, click Edit Dashboard.
  3. Hover over the upper-left corner of the Elected Office Results chart and click the Configure button Configure.
  4. Click the Series tab.
  5. Scroll to the bottom of the Series options list and click + series.
  6. Type the name of a new party and click Add.
  7. Click the color swatch next to the new party name and assign it the same color you configured in the map.
  8. Repeat these steps for each new party.
  9. Optionally, click the Delete button Delete element next to each party you want to remove.
  10. Click Done.
  11. Click View on the dashboard toolbar to open the View pane.
  12. From the drop-down list, choose Mobile
  13. Repeat the steps to update the Elected Office Results chart for the mobile view.
  14. On the dashboard toolbar, click Save Save and choose Save.

Remove the jurisdiction type filter

You can use the Election Results Dashboard app to display results for different jurisdiction types, such as county, municipality, or precinct, in the same application. In many cases, you may only need to display results for a single jurisdiction type. In this case, the jurisdiction type filter is unnecessary and can be removed.

To remove the jurisdiction type filter, complete the following steps:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results Dashboard.
  2. From the item page, click Edit Dashboard.
  3. Hover over the upper-right corner of the Jurisdiction Type filter and click the Delete button Delete element.
  4. Click Delete to confirm that you want to delete the element.
  5. Click View on the dashboard toolbar to open the View pane.
  6. From the drop-down list, choose Mobile, and then click the Drawer tab.
  7. Hover over the upper-right corner of the Jurisdiction Type filter and click the Delete button Delete element.
  8. On the dashboard toolbar, click Save Save and choose Save.

Remove the round filter

You can use the Election Results Dashboard app to display results for ranked choice voting contests. The round filter can be used to explore the results for the contest after each round. If you are not using ranked choice voting, the round filter is unnecessary and can be removed.

Complete the steps below to remove the round filter:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results Dashboard.
  2. Open the item page and click Edit Dashboard.
  3. Hover over the upper-right corner of the Round filter and click the Delete button Delete element.
  4. Click Delete to confirm that you want to delete the element.
  5. Click View on the dashboard toolbar to open the View pane.
  6. From the drop-down list, choose Mobile, and then click the Drawer tab.
  7. Hover over the upper-right corner of the Round filter and click the Delete button Delete element.
  8. On the dashboard toolbar, click Save Save and choose Save.

Modify voting method metrics

By default, three voting method metrics are included in the Election Results Dashboard app: Mail-in, Early In Person, and Election Day. Communities may use different terms to refer to these methods; for example, a community may refer to Absenteeinstead of Mail-in, or they may not offer all methods. In these cases, you may want to update the voting methods that are reported in the Election Results Dashboard app.

Update the map pop-up

To update the map pop-up, complete the following steps:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results - Voter Turnout web map.
  2. From the item page, click Open in Map Viewer.
  3. On the Contents (dark) toolbar, click Layers Layers to open the Layers pane, and then click the Voter Turnout layer.
  4. On the Settings (light) toolbar, click Pop-ups Pop-ups to open the Pop-ups pane.
  5. Click the Arcade - Voting Turnout element and click Edit expression.

    The expression returns a table with a header row and three content rows for Mail-in, Early In Person, and Election Day. Each content row is surrounded with some HTML comments, such as <!-- Begin Mail-in Row --> and <!-- End Mail-in Row -->.

  6. If you want to remove a voting method because it doesn't apply, delete everything between the Begin and End comment lines.
  7. If you want to change the voting method term, make the changes to the code in the table, and then click Done.
  8. On the Contents (dark) toolbar, click Save and open Save and open and choose Save Save.

Update the dashboard indicators

To update the dashboard indicators, complete the following steps:

  1. Verify that you are signed in to your ArcGIS organization and browse to the Election Results Dashboard.
  2. From the item page, click Edit Dashboard.
  3. Click the Voter Turnout tab.
  4. To remove a voting method indicator, hover over the upper-left corner of the indicator and click the Delete button Delete element.
  5. To change the name of the voting method that appears in an indicator, hover over the upper-left corner of the voting method indicator and click the Configure button Configure.
  6. Click the General tab.
  7. Next to Title, click Edit and update the text you want to display in the indicator.
  8. Click Done.
  9. Click View on the dashboard toolbar to open the View pane.
  10. From the drop-down list, choose Mobile, and then click the Voting Method tab.
  11. Repeat the steps to update the voting method indicators for the mobile view.
  12. On the dashboard toolbar, click Save Save and choose Save.

Schedule election result updates

The Election Result solution includes a Data Pipelines pipeline that can be used to routinely update election results. The pipeline is configured to load the ElectionResults CSV item included with the solution into the ElectionResults feature layer. The pipeline can be customized to pull this information from a public url, cloud storage, or database. The pipeline can be used to automate updates to the Election Results Dashboard by scheduling updates to run at a regular interval.

To schedule election result updates, complete the following steps:

  1. In a browser, sign in to your ArcGIS organization, and then browse to the Election Results Pipeline pipeline.
  2. Click Open in Data Pipelines.

    The data pipeline editor opens and you can edit your diagram. By default, the input is configured for the ElectionResult CSV that is included in the solution. You can download and edit this CSV, upload it back to the item, and when you run the pipeline it will load the rows into the ElectionResults feature layer.

  3. Optionally, click Inputs on the editor toolbar and add the desired input type for the source of your election results table.
  4. Configure the input and click Preview.

    The preview loads. Click the Table preview preview tab to view a tabular representation of the dataset.

  5. Delete the original ElectionResults CSV input and connect your new input to the Replace Election Results output.

    If your input schema differs from the output schema you can use the tools available under Tools on the editor toolbar to clean and transform data prior to loading into the output.

  6. Click Save on the editor toolbar.
  7. On the action bar at the top of the canvas, click Run.

    The data pipeline is now running and the Latest run details console appears. Once the process is complete, the feature layer is shown on the Results tab and you can verify that the records have been loaded into the ElectionResults feature layer.

  8. Click Schedule on the editor toolbar and click Create task.
  9. Provide a title for the task, configure the schedule details, and click Save.

    The task is created and the data pipeline is scheduled to run.

Share historical results

You can deploy and configure the Election Results solution multiple times to share results for different elections. You can then share each of the Election Results Dashboard apps with a single Portfolio app and embed them on your website.

To create a historical Election Results app using the Portfolio ArcGIS Instant Apps template, complete the following steps:

  1. Sign in to your ArcGIS organization.
  2. Click the Apps button Apps in the header of the site and choose Instant Apps.
  3. Search for Portfolio.
  4. On the Portfolio gallery card, click Choose.
  5. Specify a title and tags for your app, and then click Create app.
  6. Click Step 1. Portfolio, and then click Add new section.
  7. Click Browse for content, search for one of your Election Results Dashboard apps, and click Select.
  8. Optionally, modify the Section name value to be specific to the election; for example, 2024 General Election.
  9. Click Done.
  10. Repeat these steps for each Election Results Dashboard app you want to share.
  11. Optionally, change the App layout setting.
  12. Click Publish and click Confirm.
  13. In the Share dialog box, click Change sharing settings, select Everyone (public), and click Save.
  14. Embed the Historical Election Results Dashboard app on your election website.