Visualize Contributions from Senior Executives that were Refunded | Scribe

    Visualize Contributions from Senior Executives that were Refunded

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

    Want to make guides like this in seconds? Yes, it's really that fast.

    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe