RequestType: ReportAnalysis

! The TargetElection statement does two tings - selects the date of the general election on which to base the analysis
! and automatically filters the data to only include eligible voters for that election.

TargetElection: 2020

! The Party4 field referenced below is a dynamically calculated data field that categories the
! 15 unique parties recognized by the state into 4 choices - DEM, REP, NPA, OTH.

GroupBy: (Party4)

Report: '2020_Election_Turnout'

Column: 'Turnout' (VoterVoted == Y)
Compute: '% Turnout' ( 'Turnout' % Total )

Column: 'White' (RaceName == 'White')
Column: 'White Voters' (RaceName == 'White') AND (VoterVoted==Y)
Compute: '% White Turnout' ('White Voters' % 'White')

! --- Repeat for Black

Column: 'Black' (RaceName == 'Black')
Column: 'Black Voters' (RaceName == Black) AND (VoterVoted==Y)
Compute: '% Black Turnout' ('Black Voters' % 'Black')

! --- Repeat for Hispanic

Column: 'Hispanic' (RaceName == Hispanic)
Column: 'Hispanic Voters' (RaceName == Hispanic) AND (VoterVoted==Y)
Compute: '% Hispanic Turnout' ('Hispanic Voters' % 'Hispanic')

! ---  Repeat for Other Races
! ---  NOTE: Compound criteria on RaceName is enclosed in double parentheses.

Column: Other ((RaceName <> White) AND (RaceName <> Black) AND (RaceName <> Hispanic))
Column: 'Other Voters' (VoterVoted==Y) AND
   ((RaceName <> White) AND (RaceName <> Black) AND (RaceName <> Hispanic))
Compute: '% Other Turnout' ('Other Voters' % 'Other')