Toggle navigation
Settings
Cancel changes
ID
A unique ID for the visualisation, used in the link
Title
Title displayed on top of the application
Logo
Data Source
Donations by Projects.xlsx
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
Donation
Board
ABC TNF Board Project
12
3863.65
0.0056
321.9708333
Donation
Individual
Amaravathipudur School
24
11294.27
0.0163
470.5945833
Donation
Individual
Anbalayam
77
20406.22
0.0294
265.0158442
Donation
Individual
Anbu Karangal
6
1116.25
0.0016
186.0416667
Donation
Individual
Arumugam & Gunantha Mudaliar Education Project
3
4750.0
0.0068
1583.3333333
Donation
Chapter
Bay Area Chapter
1
768.47
0.0011
768.47
Donation
Individual
Bharathvaja Ashram-Poor Children Education
1
4750.0
0.0068
4750.0
Donation
Individual
Center for Medical Genetics Project
12
20022.0
0.0289
1668.5
Donation
Chapter
Central Florida Chapter
12
1458.25
0.0021
121.5208333
Donation
District
Chennai District Project
3
807.5
0.0012
269.1666667
Donation
Chapter
Chicago Chapter
21
13907.65
0.02
662.2690476
Donation
Convention
Columbus OH Convention
11
4283.98
0.0062
389.4527273
Donation
Chapter
Connecticut Chapter
27
4654.15
0.0067
172.3759259
Donation
District
Cuddalore District Project
1
190.0
0.0003
190.0
Donation
Individual
Dhalavaipettai High School Building
1
200.0
0.0003
200.0
Donation
Individual
Dr. PRP Memorial Fund
27
4261.7
0.0061
157.8407407
Donation
Individual
Dr. Sunita & Soloman Memorial Fund
1
190.0
0.0003
190.0
Donation
District
Erode District Project
1
2232.5
0.0032
2232.5
Donation
Individual
EssVee Foundation
2
950.0
0.0014
475.0
Donation
Individual
Eye Camp
1
95.0
0.0001
95.0
Donation
Natural Disaster
Flood Relief
1
1225.0
0.0018
1225.0
Donation
Chapter
Georgia Chapter
11
3990.0
0.0058
362.7272727
Donation
Individual
GHSS Thennilai Scholarship
2
1187.5
0.0017
593.75
Donation
Individual
Gift Foundation #425-11-i Project
4
25229.15
0.0364
6307.2875
Donation
Individual
Gita Krishnamurthy Trust
5
3809.5
0.0055
761.9
Donation
Individual
Govt. Vinobha Bhave Higher Sec. School Project
4
20662.5
0.0298
5165.625
Donation
Chapter
Greater Boston Chapter
27
6754.45
0.0097
250.1648148
Donation
Individual
Gurupriya Vision Balanethra Phase II
1
5035.0
0.0073
5035.0
Donation
Chapter
Houston Chapter
48
27190.9
0.0392
566.4770833
Donation
Natural Disaster
Hurricane Harvey TX 2017 Relief Fund
18
2960.0
0.0043
164.4444444
Donation
Individual
Kalapai Project
4
3562.5
0.0051
890.625
Donation
Individual
Kanavagam Project
139
51216.4
0.0738
368.4633094
Donation
Individual
Kanyakumari District Project
1
323.0
0.0005
323.0
Donation
District
Karur District Projects
1
190.95
0.0003
190.95
Donation
Individual
Kasthurba Gandhi Kanya Gurukulam
1
47500.95
0.0685
47500.95
Donation
Individual
KCSK Ravindran Special School
1
7790.0
0.0112
7790.0
Donation
Individual
Kundrakudi Adigalar Project
2
1045.0
0.0015
522.5
Donation
Individual
Laia Foundation
3
14059.67
0.0203
4686.5566667
Donation
Board
Life Membership
106
30285.0
0.0437
285.7075472
Donation
Chapter
Memphis Chapter
69
9574.26
0.0138
138.7573913
Donation
Chapter
Michigan Chapter
2
2018.75
0.0029
1009.375
Donation
District
Nagapattinam District Project
6
4465.0
0.0064
744.1666667
Donation
District
Namakkal District Project
17
9880.0
0.0142
581.1764706
Donation
Chapter
New Jersey Chapter
1
47.5
0.0001
47.5
Donation
Chapter
New York Chapter
13
5662.5
0.0082
435.5769231
Donation
Convention
NJ Convention
15
46411.0
0.0669
3094.0666667
Donation
Chapter
Ohio Central Chapter
3
237.5
0.0003
79.1666667
Donation
Chapter
Philadelphia Chapter
4
1995.0
0.0029
498.75
Donation
District
Salem District Project
2
5082.5
0.0073
2541.25
Donation
Individual
Senthilkumar Mahadevan & Uma Senthilkumar Trust
1
237.5
0.0003
237.5
Dynamic Columns
(Optional: can be used to create new columns based on the available columns in data)
Column Name
Formula
Add New Column
Date column
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
Filter columns
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Type of Donation
Type of Project
Projects
Quantity
Amount
% of Sales
Avg Price
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Add Size Metric
Colours
(ratios derived from metrics)
Name
Numerator
Denominator
Display format
Units
Colour
Min
Max
Stop values
Stop points
Ignore Outliers%
1
Donation Amount
Donation Quantity
Average Price
Sales %
1
Donation Amount
Donation Quantity
Average Price
Sales %
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
1
Donation Amount
Donation Quantity
Average Price
Sales %
1
Donation Amount
Donation Quantity
Average Price
Sales %
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
1
Donation Amount
Donation Quantity
Average Price
Sales %
1
Donation Amount
Donation Quantity
Average Price
Sales %
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
1
Donation Amount
Donation Quantity
Average Price
Sales %
1
Donation Amount
Donation Quantity
Average Price
Sales %
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Add Color Field
Additional options »
Max. boxes
Max boxes in a treemap. Keep under 200 for speed.
Max. filter entries
Number of top entries to show in filter dropdown
Cache time (min)
Report won't be refreshed for this long
Screen width
Width of the screen. 0 for auto layout.
Treemap height %
Total height as a % of width.
Aspect ratio
Wider boxes (>1) or taller boxes (<1)
Max font size
Text inside boxes will not exceed this size
Roles with access
Space seperated
roles
that can view the data
Admin roles
Space seperated
roles
that can change this page (
admin
always can)
Calendar uses size
Instead of colouring calendar by colour metric, use size metric
Colour scale
Colours of the low, medium, high and invalid entries
Top and bottom tables
Show the top X and bottom Y items
Theme
v3
slate
flatly
Colour theme
Submit
Cancel changes
Delete application
(no undo)