HelloVoter icon indicating copy to clipboard operation
HelloVoter copied to clipboard

UI for building an analytics query

Open cormander opened this issue 6 years ago • 0 comments

As an administrator I need a UI to construct a query that gets ran against the database so that I can review the information with various charts.

http://localhost:3000/HelloVoterHQ/#/analytics/

The UI needs to let you:

  • select which data type you want returned / aggregated
  • add a new constraint to the query based on a data type (name, location, party, custom question, etc)
    • each constraint needs to define whether it's required or optional
    • each constraint needs to define whether this includes or excludes data, based on an operator (matches, doesn't match, less than, greater than, is equal, is not equal)
  • select the type of chart to use on the display

For example:

  • Select data type "Party"
  • Add constraint of question "votes in primary elections" is equal to true
  • Add constraint of question "voter ID laws help democracy" is greater than neutral (they answered "agree" or "strongly agree", but they're numerical behind the scenes)
  • Select display a bar chart

On submit, send the options to an endpoint, and expect a JSON object back to display as a bar chart, for example:

Party A: 10% Party B: 67% Party C: 55% Party D: 22%

cormander avatar Jan 01 '19 18:01 cormander