AnsweredAssumed Answered

Election Mapping - How to calculate and display Total Votes so far?

Question asked by AWallick@yolocounty.org_Yolo on May 23, 2018
Latest reply on May 31, 2018 by KGerrow-esristaff

Hi all,

 

I’m reaching out for help on this. We have a very limited time frame to get this done, so any help you can give is greatly appreciated! There’s a bit to it, so I’m going to try to make this post easy to read.

 

Problem:

We’ve gotten the word that we need to be showing vote totals (for all reporting precincts) for each contest. Any idea how we do this?

      What we need to include:

  • Total votes so far
  • Top vote-getter
  • Preferably a chart showing vote totals for each candidate

 

Format:

I’m hoping to do this in the Map Series story map template, and would like it to be in the side panel if possible. See below for an example. We want this to update whenever we update the data.

 

Data structure:

Below is our feature class table. We will have vote totals (Total Ballots field) coming in by precinct on election night, but currently we don’t have a field totaling those up.

 

 

We also have a related table (see below) with totals for each precinct by candidate.

 

Solutions needed:

  1. way to calculate or pass into the story map the vote totals for each candidate
    1. Is there a SUM operator somewhere in ArcGIS Online or Arcade that we could make use of?
    2. If we have to create new tables on the back end, what's the best way to do that and tie it in to the story map?
  2. Some method of displaying those totals in a chart or table, preferably in the side panel of the story map.
    1. A pie chart would be ideal, but a table or just dynamic text would work as well.
    2. We really want this to be dynamic; we don't want to have to update a static picture manually. 

Outcomes