Visualize Contributions from Senior Executives that were Refunded | Scribe

    Visualize Contributions from Senior Executives that were Refunded

    • Kathy Qian |
    • 30 steps |
    • 4 minutes
    1
    Navigate to [https://tools.codefordemocracy.org/](https://tools.codefordemocracy.org/)
    2
    Launch the "Create a Query" workflow
    3
    Select the "Find contributions from individual donors who work as a Job List" recipe
    4
    Click "Go to Next Step"
    5
    Choose the "Senior Executives" job list
    6
    Review the included terms and click "Go to Next Step"
    7
    Click "Numerical Filters"
    8
    Enter "-250" as the max transaction amount in order to look into large refunds
    9
    Click "Go to Next Step"
    10
    Review the results and click "Go to Next Step"
    11
    Name the query "Large Contributions from Senior Executives that were Refunded"
    12
    Click "Create Query"
    13
    Go to the "Create a Visualization" workflow
    14
    Choose "Chart"
    15
    Click "Go to Next Step"
    16
    Select the "Large Contributions from Senior Executives that were Refunded" query that you just created
    17
    Click "Go to Next Step"
    18
    Select "transaction_amt" as the column for aggregation
    19
    Select "sum" as the aggregation
    20
    Group by "recipient_cmte_nm"