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
Transformed data file.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
ART SURROGACY
5
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
BUS VISA INDSPOUSE
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
BUSINESS VISA
44
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
BUSINESS VISA TRANSFER
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
CONFERENCE VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
DIPLOMATIC DEPENDANT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
DIPLOMATIC VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
EMPLOYMENT VISA
2
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
EMPLOYMENT VISA INDSPOUSE
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
ENTRY VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
LONG TERM VISA TRANSFER
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
MEDICAL ATTENDENT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
MEDICAL VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
MISSIONARY VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
PILGRIMAGE VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
PROJECT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
RESEARCH VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
STUDENT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
TOURIST VISA
900
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
TRANSIT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Dec
VISIT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
ART SURROGACY
1
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
BUS VISA INDSPOUSE
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
BUSINESS VISA
48
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
BUSINESS VISA TRANSFER
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
CONFERENCE VISA
24
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
DIPLOMATIC DEPENDANT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
DIPLOMATIC VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
EMPLOYMENT VISA
2
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
EMPLOYMENT VISA INDSPOUSE
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
ENTRY VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
LONG TERM VISA TRANSFER
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
MEDICAL ATTENDENT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
MEDICAL VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
MISSIONARY VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
PILGRIMAGE VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
PROJECT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
RESEARCH VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
STUDENT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
TOURIST VISA
604
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
TRANSIT VISA
1
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Nov
VISIT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
ART SURROGACY
2
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
BUS VISA INDSPOUSE
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
BUSINESS VISA
40
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
BUSINESS VISA TRANSFER
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
CONFERENCE VISA
21
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
DIPLOMATIC DEPENDANT VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
DIPLOMATIC VISA
0
ARGENTINA
ARGENTINA-BUENOSAIRES
2012
Oct
EMPLOYMENT VISA
4
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
Year
Month
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
COUNTRY
Year
MISSION
VisaType
Month
Visa Count
Filter columns
COUNTRY
Year
MISSION
VisaType
Month
Visa Count
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
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
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
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
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
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
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
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
COUNTRY
MISSION
Year
Month
VisaType
Visa Count
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
Visa Count
Country
Mission
Year
Visa Type
1
Visa Count
Country
Mission
Year
Visa Type
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)