Save for Later
This guide was created with Scribe in
4 minutes.
Sign in and create your own!
Visualize Contributions from Senior Executives that were Refunded
Kathy Qian
|
0 steps
|
4 minutes
Codefordemocracy
Datawrapper
1
Navigate to [https://tools.codefordemocracy.org/](https://tools.codefordemocracy.org/)
2
Launch the "Create a Query" workflow
Zoom Saved
3
Select the "Find contributions from individual donors who work as a Job List" recipe
Zoom Saved
4
Click "Go to Next Step"
Zoom Saved
5
Choose the "Senior Executives" job list
Zoom Saved
6
Review the included terms and click "Go to Next Step"
Zoom Saved
7
Click "Numerical Filters"
Zoom Saved
8
Enter "-250" as the max transaction amount in order to look into large refunds
Zoom Saved
9
Click "Go to Next Step"
Zoom Saved
10
Review the results and click "Go to Next Step"
Zoom Saved
11
Name the query "Large Contributions from Senior Executives that were Refunded"
Zoom Saved
12
Click "Create Query"
Zoom Saved
13
Go to the "Create a Visualization" workflow
Zoom Saved
14
Choose "Chart"
Zoom Saved
15
Click "Go to Next Step"
Zoom Saved
16
Select the "Large Contributions from Senior Executives that were Refunded" query that you just created
Zoom Saved
17
Click "Go to Next Step"
Zoom Saved
18
Select "transaction_amt" as the column for aggregation
Zoom Saved
19
Select "sum" as the aggregation
Zoom Saved
20
Group by "recipient_cmte_nm"
Zoom Saved
Want to make guides like this in seconds? Yes, it's really that fast.
Show Me How
Have something to say?
Create an account to leave messages for the author to see!
Create an account
Feedback
This Scribe is in tip-top shape!
Leave feedback if there are any issues with this Scribe