A unique ID for the visualisation, used in the link
Title displayed on top of the application
DB Type
Host
Port
Database
Username
Password
Table
Date Transaction Type Num Memo/Description Amount Billing Address Donor Donation Range
11/13/2017 Receipt 1601 nan 1000.0 PA DONOR $1000-$1999
11/20/2017 Receipt 1612 nan 300.0 IL DONOR $100-$499
07/03/2017 Receipt 1210 nan 500.0 NH DONOR $500-$999
12/29/2017 Receipt 1732 nan 400.0 MI DONOR $100-$499
09/15/2017 Receipt 1448 nan 10.0 UNKNOWN DONOR Less than $100
08/22/2017 Receipt 1384 nan 350.0 CA DONOR $100-$499
09/05/2017 Receipt 1403 nan 400.0 UNKNOWN DONOR $100-$499
02/21/2018 Receipt 1935 nan 100.0 TN DONOR $100-$499
12/19/2017 Receipt 1699 nan 25.0 PA DONOR Less than $100
07/03/2017 Receipt 1222 nan 7.0 UNKNOWN DONOR Less than $100
10/10/2017 Receipt 1521 nan 50.0 TN DONOR Less than $100
02/21/2018 Receipt 1943 nan 99.0 TN DONOR Less than $100
02/12/2018 Receipt 1884 nan 250.0 NY DONOR $100-$499
08/17/2017 Receipt 1400 Amazon Smiles Donation 57.96 WA DONOR Less than $100
11/20/2017 Receipt 1609 nan 41.47 WA DONOR Less than $100
02/12/2018 Receipt 1882 nan 63.24 WA DONOR Less than $100
03/19/2018 Receipt 2089 ORIG CO NAME:AMNEAL NJ CO ENTRY DESCR:PY SEC:CTX IND ID: 75563 ORIG ID:1900186021 10000.0 NJ DONOR $10000-$24999
12/06/2017 Receipt 1651 nan 20.0 UNKNOWN DONOR Less than $100
07/12/2017 Receipt 1317 nan 300.0 UNKNOWN DONOR $100-$499
11/06/2017 Receipt 1593 nan 25.0 IL DONOR Less than $100
09/11/2017 Receipt 1440 nan 500.0 IL DONOR $500-$999
05/22/2017 Receipt 1078 nan 500.0 MD DONOR $500-$999
12/31/2017 Receipt 1795 nan 10000.0 NJ DONOR $10000-$24999
12/31/2017 Receipt 1797 nan 100.0 MA DONOR $100-$499
12/26/2017 Receipt 1725 nan 1599.0 MD DONOR $1000-$1999
12/31/2017 Receipt 1740 nan 300.0 PA DONOR $100-$499
04/27/2017 Receipt 1040 nan 25.0 UNKNOWN DONOR Less than $100
03/02/2018 Receipt 2017 nan 51.0 FL DONOR Less than $100
06/15/2017 Receipt 1172 nan 100.0 NJ DONOR $100-$499
10/03/2017 Receipt 1474 nan 101.0 NJ DONOR $100-$499
04/27/2017 Receipt 1042 nan 100.0 UNKNOWN DONOR $100-$499
10/03/2017 Receipt 1476 nan 30.0 NY DONOR Less than $100
10/20/2017 Receipt 1567 nan 25.0 NY DONOR Less than $100
12/29/2017 Receipt 1727 This was originally documented under TNF USA Corpus Fund account and then changed to Kundarkudi Adigalar project - See attached supporting documents. 100.0 FL DONOR $100-$499
12/18/2017 Receipt 1695 nan 50.0 NJ DONOR Less than $100
11/09/2017 Receipt 1598 nan 340.0 TN DONOR $100-$499
12/27/2017 Receipt 1772 nan 300.0 PA DONOR $100-$499
04/10/2017 Receipt 1012 nan 100.0 UNKNOWN DONOR $100-$499
02/12/2018 Receipt 1880 nan 300.0 TX DONOR $100-$499
03/02/2018 Receipt 2036 nan 100.0 FL DONOR $100-$499
03/07/2018 Receipt 2054 nan 100.0 NJ DONOR $100-$499
05/30/2017 Receipt 1136 PayPal Donation - Deposit Received on May 30, 2017 100.0 UNKNOWN DONOR $100-$499
02/26/2018 Receipt 1988 nan 50.0 FL DONOR Less than $100
03/02/2018 Receipt 2014 nan 100.0 FL DONOR $100-$499
10/20/2017 Receipt 1562 nan 160.0 NY DONOR $100-$499
12/31/2017 Receipt 1796 nan 500.0 IL DONOR $500-$999
06/15/2017 Receipt 1168 nan 51.0 UNKNOWN DONOR Less than $100
07/12/2017 Receipt 1326 nan 100.0 UNKNOWN DONOR $100-$499
10/10/2017 Receipt 1512 nan 100.0 PA DONOR $100-$499
11/27/2017 Receipt 1622 nan 100.0 PA DONOR $100-$499
Dynamic Columns (Optional: can be used to create new columns based on the available columns in data)
Column Name Formula
Metrics (can be used for size, and to derive colours)
Name Field Aggregation Display format Units
Colours (ratios derived from metrics)
Name Numerator Denominator Display format Units Colour Min Max Stop values Stop points Ignore Outliers%

Additional options »

Max boxes in a treemap. Keep under 200 for speed.
Number of top entries to show in filter dropdown
Report won't be refreshed for this long
Width of the screen. 0 for auto layout.
Total height as a % of width.
Wider boxes (>1) or taller boxes (<1)
Text inside boxes will not exceed this size
Space seperated roles that can view the data
Space seperated roles that can change this page (admin always can)
Instead of colouring calendar by colour metric, use size metric
Colours of the low, medium, high and invalid entries
Show the top X and bottom Y items
Colour theme

Cancel changes