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
SkillsAnalytics.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
EMPID
Skill
Skill Level
Utilization
Grade
Office City
Office Country
Vertical
max util
EMP1
Skill1
10+ yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill2
10+ yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill3
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill4
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill5
Native Speaker or Functional Equivalent
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill6
Advanced Professional Proficiency
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill7
Limited Social Proficiency
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill8
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill9
Graduated
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill10
2-5 yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill11
10+ yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill12
10+ yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill13
5-10 yrs
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill14
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill15
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill16
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill17
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill18
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill19
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill20
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill21
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP1
Skill22
Mastery
85.5704698
Senior Manager
NewYork
USA
Analytics
101.3422819
EMP2
Skill23
Certified
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill24
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill25
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill26
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill27
Foundation
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill28
Foundation
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill29
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill30
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill5
Advanced Professional Proficiency
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill7
Native Speaker or Functional Equivalent
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill31
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP2
Skill32
Intermediate
58.38926174
Senior Analyst
NewYork
USA
Design
101.3422819
EMP3
Skill19
Advanced
10.06711409
Director
NewYork
USA
Visualization
101.3422819
EMP3
Skill21
Mastery
10.06711409
Director
NewYork
USA
Visualization
101.3422819
EMP3
Skill22
Mastery
10.06711409
Director
NewYork
USA
Visualization
101.3422819
EMP4
Skill33
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill34
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill35
Graduated
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill36
< 2 yrs
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill37
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill38
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill39
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill40
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill41
Intermediate
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill42
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill43
Advanced
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill44
Intermediate
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
EMP4
Skill45
2-5 yrs
18.29268293
Senior Analyst
NewYork
USA
Analytics
101.3422819
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
EMPID
Office Country
Vertical
Grade
Office City
Skill Level
Skill
Utilization
max util
Filter columns
Office Country
Skill
Vertical
Office City
EMPID
Skill Level
Utilization
Grade
max util
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
EMPID
Skill
Skill Level
Utilization
Grade
Office City
Office Country
Vertical
max util
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
EMPID
Skill
Skill Level
Utilization
Grade
Office City
Office Country
Vertical
max util
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
EMPID
Skill
Skill Level
Utilization
Grade
Office City
Office Country
Vertical
max util
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
EMPID
Skill
Skill Level
Utilization
Grade
Office City
Office Country
Vertical
max util
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
Skills Count
Average Utilization
Count of Employees
max
1
Skills Count
Average Utilization
Count of Employees
max
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
Skills Count
Average Utilization
Count of Employees
max
1
Skills Count
Average Utilization
Count of Employees
max
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)