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
Glb_Download_Speed_May18.xlsx
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
1
Norway
62.7
80.17
0.782088062866
Europe & Central Asia
High income
0.782088062866
2
Qatar
59.81
35.66
1.67722938867
Middle East & North Africa
High income
1.67722938867
3
Iceland
58.57
155.25
0.377262479871
Europe & Central Asia
High income
0.377262479871
4
Singapore
54.96
170.99
0.321422305398
East Asia & Pacific
High income
0.321422305398
5
United Arab Emirates
54.18
30.92
1.75226390686
Middle East & North Africa
High income
1.75226390686
6
Netherlands
52.19
82.28
0.634297520661
Europe & Central Asia
High income
0.634297520661
7
Bulgaria
51.9
44.98
1.15384615385
Europe & Central Asia
Upper middle income
1.15384615385
8
Australia
50.38
30.53
1.65018015067
East Asia & Pacific
High income
1.65018015067
9
Hungary
49.44
95.31
0.518728360088
Europe & Central Asia
High income
0.518728360088
10
Canada
48.51
77.98
0.622082585278
North America
High income
0.622082585278
11
Belgium
47.05
60.91
0.772451157445
Europe & Central Asia
High income
0.772451157445
12
Luxembourg
46.66
64.24
0.726338729763
Europe & Central Asia
High income
0.726338729763
13
Malta
45.08
49.01
0.919812283208
Middle East & North Africa
High income
0.919812283208
14
New Zealand
43.42
75.71
0.573504160613
East Asia & Pacific
High income
0.573504160613
15
Switzerland
43.12
93.36
0.461868037704
Europe & Central Asia
High income
0.461868037704
16
South Korea
42.71
117.62
0.363118517259
East Asia & Pacific
High income
0.363118517259
17
Taiwan
42.06
55.94
0.751877011083
East Asia & Pacific
High income
0.751877011083
18
Denmark
41.51
79.75
0.520501567398
Europe & Central Asia
High income
0.520501567398
19
Czech Republic
41.32
40.42
1.02226620485
Europe & Central Asia
High income
1.02226620485
20
Lithuania
39.58
70.22
0.563657077756
Europe & Central Asia
High income
0.563657077756
21
Sweden
39.17
92.93
0.421500053804
Europe & Central Asia
High income
0.421500053804
22
Montenegro
38.56
25.77
1.49631354288
Europe & Central Asia
Upper middle income
1.49631354288
23
Greece
36.93
17.71
2.08526256352
Europe & Central Asia
High income
2.08526256352
24
Macedonia
36.25
23.68
1.5308277027
Europe & Central Asia
Upper middle income
1.5308277027
25
Albania
35.9
14.52
2.47245179063
Europe & Central Asia
Upper middle income
2.47245179063
26
Finland
35.74
47.37
0.754485961579
Europe & Central Asia
High income
0.754485961579
27
Croatia
35.59
25.45
1.39842829077
Europe & Central Asia
Upper middle income
1.39842829077
28
Austria
34.36
35.68
0.963004484305
Europe & Central Asia
High income
0.963004484305
29
Turkey
34.35
17.41
1.97300402068
Europe & Central Asia
Upper middle income
1.97300402068
30
Lebanon
33.9
5.57
6.08617594255
Middle East & North Africa
Upper middle income
6.08617594255
31
France
33.75
73.52
0.459058759521
Europe & Central Asia
High income
0.459058759521
32
Italy
33.22
40.32
0.823908730159
Europe & Central Asia
High income
0.823908730159
33
Estonia
33.07
42.07
0.786070834324
Europe & Central Asia
High income
0.786070834324
34
Serbia
32.56
32.53
1.00092222564
Europe & Central Asia
Upper middle income
1.00092222564
35
Spain
32.54
88.08
0.369436875568
Europe & Central Asia
High income
0.369436875568
36
Romania
31.05
109.26
0.284184514003
Europe & Central Asia
Upper middle income
0.284184514003
37
Moldova
30.95
46.48
0.665877796902
Europe & Central Asia
Lower middle income
0.665877796902
38
Slovenia
30.7
42.2
0.727488151659
Europe & Central Asia
High income
0.727488151659
39
China
30.45
78.98
0.385540643201
East Asia & Pacific
Upper middle income
0.385540643201
40
Macau (SAR)
30.44
89.74
0.339202139514
nan
nan
0.339202139514
41
Hong Kong SAR
30.24
141.43
0.21381602206
East Asia & Pacific
High income
0.21381602206
42
Slovakia
29.95
43.46
0.689139438564
Europe & Central Asia
High income
0.689139438564
43
Latvia
29.88
52.22
0.572194561471
Europe & Central Asia
High income
0.572194561471
44
Portugal
28.27
64.49
0.438362536827
Europe & Central Asia
High income
0.438362536827
45
Kuwait
28.01
17.94
1.5613154961
Middle East & North Africa
High income
1.5613154961
46
Georgia
27.85
18.9
1.47354497354
Europe & Central Asia
Lower middle income
1.47354497354
47
United States
27.76
92.66
0.299589898554
North America
High income
0.299589898554
48
Germany
27.15
56.57
0.479936362029
Europe & Central Asia
High income
0.479936362029
49
Cyprus
27.12
20.64
1.31395348837
Europe & Central Asia
High income
1.31395348837
50
Oman
27.05
17.62
1.53518728717
Middle East & North Africa
High income
1.53518728717
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
Income group
Region
Mobile Download Mbps
FixedLine Download Speeds
Country
Rank
Speed Ratio
Download Ratio
Filter columns
Region
Income group
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Download Ratio
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Rank
Country
Mobile Download Mbps
FixedLine Download Speeds
Speed Ratio
Region
Income group
Download Ratio
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
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
1
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
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
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
1
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
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
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
1
Region
Mobile Download
Fixed Line Download
Country
Income group
Download Ratio
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)