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
Daily Attendance.xlsx
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
Andhra Pradesh
Coastal Andhra
ASE
B.Veerababu
1:53
1353.63
196.2498353
1.0
Andhra Pradesh
Coastal Andhra
ASM
L.Ravishankar
2:14
5131.49
29.5716393
0.666666666667
Andhra Pradesh
Coastal Andhra
ASM
Potti Venkata Sukumar
2:53
731.02
146.5470062
1.0
Andhra Pradesh
Coastal Andhra
SO
Ambedhkar T
0:00
407.97
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
B.Gopi
6:34
2809.15
7.2197543
0.303854875283
Andhra Pradesh
Coastal Andhra
SO
Bb. Naidu
2:58
2419.5
68.9802451
0.0469798657718
Andhra Pradesh
Coastal Andhra
SO
Boddu Sudhakar
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
C.Mallikarjuna
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
Chodagudi Srikanth
0:00
189.14
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
Deepak Kumar
3:20
1248.98
0.4380188
0.174603174603
Andhra Pradesh
Coastal Andhra
SO
K.Chandra Sekhar
8:00
412.89
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
M.Srinadh
1:42
33.96
28.258971
0.223529411765
Andhra Pradesh
Coastal Andhra
SO
R.Ravindra Prasad
2:05
461.73
76.9546483
1.0
Andhra Pradesh
Coastal Andhra
SO
R.Venkatesh
0:00
298.38
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
Rathna Gopal
0:00
912.95
0.0
nan
Andhra Pradesh
Coastal Andhra
SO
S.Krishna
8:00
411.43
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
B.Chaitanya
0:00
615.13
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
B.Jagannadha Rao
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
B.Ramanjaneyulu
7:30
7309.42
9.4703631
0.492207792208
Andhra Pradesh
Coastal Andhra
SR
Bala Nageswara Rao
0:00
237.59
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
Ch.Nagaraju
7:41
2673.89
11.7144461
0.502835538752
Andhra Pradesh
Coastal Andhra
SR
Ch.Vamsi
2:11
51.94
0.799111
0.978260869565
Andhra Pradesh
Coastal Andhra
SR
D.Prashanth
5:58
748.19
4.0137736
0.484905660377
Andhra Pradesh
Coastal Andhra
SR
Durgarao Naik Banavath
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
K.Uma Mahesh
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
L.Chennakesava
0:00
385.59
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
M Govinda Raju
6:29
98.07
1.019644
0.602272727273
Andhra Pradesh
Coastal Andhra
SR
M.Ganesh
6:17
1105.17
5.2886001
0.300230946882
Andhra Pradesh
Coastal Andhra
SR
M.Nagendra Babu
6:24
2556.24
1.2641105
0.417910447761
Andhra Pradesh
Coastal Andhra
SR
M.Narayana Reddy
0:00
527.82
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
M.Raja Sekhar
0:00
1123.31
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
M.Satyanarayana
3:39
667.26
4.5163178
0.486842105263
Andhra Pradesh
Coastal Andhra
SR
Mandalapu Singaiah
0:00
352.82
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
P.Naveen Kumar
0:00
417.65
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
R.Harsha Vardhan
0:00
572.39
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
Shaik Kalesha
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
V.Arun Kumar
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SR
V.Uma Mahesh
5:53
13110.17
3.9451231
0.674057649667
Andhra Pradesh
Coastal Andhra
SR
Vuda Venkata Gopi
0:00
123.43
0.0
nan
Andhra Pradesh
Coastal Andhra
SSM
A.Mohan Krishna
4:18
13.14
2.0225516
0.405172413793
Andhra Pradesh
Coastal Andhra
SSM
C.V.Ramana Murthy
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SSM
Ch.Anand
7:43
53.07
0.8336171
0.317307692308
Andhra Pradesh
Coastal Andhra
SSM
Ch.N.K.Srinivas
8:02
83.34
0.9961667
0.33110367893
Andhra Pradesh
Coastal Andhra
SSM
Ch.Venkatarao
0:00
nan
nan
nan
Andhra Pradesh
Coastal Andhra
SSM
Chinna
0:04
nan
0.0020117
1.0
Andhra Pradesh
Coastal Andhra
SSM
Dhanush
0:00
nan
nan
nan
Andhra Pradesh
Coastal Andhra
SSM
G Venkatesh Kumar​
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SSM
G.Nagendra Kumar
0:00
nan
0.0
nan
Andhra Pradesh
Coastal Andhra
SSM
G.Naresh
7:54
149.64
0.958012
0.367412140575
Andhra Pradesh
Coastal Andhra
SSM
G.Rambabu
5:44
110.09
1.5552192
0.398496240602
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
Average Time Spent on the field
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
Filter columns
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
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
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
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
Zone
Subzone
Designation
Employee
Average Time Spent on the field
Distance travelled
Order is Rs Lacs
Call Success rate
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
Amount
Employee
TIme Spent
1
Amount
Employee
TIme Spent
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)