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
elsevier-rx-2.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
Review
Check paper status
4128
36
68.0
89285.47
Review
Co-Author service
353
20
37.0
14126.74
Review
Request more time
99
2
6.0
5928.39
Review
Withdraw manuscript
98
1
2.0
4987.47
Review
Reviewer accepts/declines invite via ema
30
1
2.0
2000.31
Review
Suggest reviewers
17
0
nan
729.5
Review
Send review comments
17
1
3.0
465.75
Review
Reviewer recognition certificate
6
0
nan
616.08
Review
Invite reviewers
6
0
nan
189.56
Review
Find reviewers
5
0
nan
100.95
Review
Publishing process and timelines
4
0
nan
290.24
Review
Other
3
0
nan
151.73
Review
Report a concern
3
0
nan
177.8
Review
Additional info required
2
0
nan
37.74
Revision
Request more time
972
25
60.0
39595.32
Revision
Check paper status
649
8
18.0
14771.39
Revision
Submit revision
268
7
16.0
10062.73
Revision
Review comments
124
6
14.0
4590.54
Revision
Change the submission
52
0
nan
1808.54
Revision
Withdraw manuscript
25
1
3.0
1069.13
Revision
Create the pdf
22
0
nan
858.9
Revision
Change authors
19
0
nan
741.32
Revision
Other
8
0
nan
309.24
Revision
LaTex Issue
4
0
nan
258.31
Revision
Figures and illustrations
3
0
nan
137.73
Submission
Change submission
391
25
56.0
14093.31
Submission
Submission requirements
370
14
27.0
14525.92
Submission
Withdraw manuscript
243
7
12.0
10488.92
Submission
Submission instructions
213
10
24.0
7921.88
Submission
Transfer article to another journal
103
3
8.0
4525.26
Submission
Create the pdf
62
2
4.0
1085.13
Submission
Other
46
0
nan
1565.24
Submission
Article type
13
1
3.0
405.07
Submission
Request more time
12
1
3.0
546.57
Submission
Where to submit
11
0
nan
401.24
Submission
Assign new editor
4
0
nan
129.7
Submission
LaTex Issue
4
2
4.0
145.72
Submission
Research data
1
0
nan
41.78
Decision
Question about a decision
723
2
3.0
33516.17
Decision
Transfer article to another journal
101
2
4.0
4413.49
Decision
Reviewer comments
62
1
3.0
2565.5
Decision
What happens after acceptance
36
1
3.0
1534.54
Decision
Change a decision
29
0
nan
1280.69
Decision
Other
28
0
nan
1084.22
Decision
How to send decision
4
0
nan
143.96
Decision
Assign another Editor
1
0
nan
41.9
No Contact Reason
No Contact Reason
265
0
nan
6757.41
After Publication
Product & services related to authoring
75
0
nan
3382.75
After Publication
Payment and invoicing
44
0
nan
3209.74
After Publication
Accessing published articles
17
1
2.0
829.96
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
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
Filter columns
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
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
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
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
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
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
Reason 1
Reason 2
Incidents
Submitted
CSAT
TAT
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
Incidents
Submitted
CSAT #
TAT #
1
Incidents
Submitted
CSAT #
TAT #
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
Incidents
Submitted
CSAT #
TAT #
1
Incidents
Submitted
CSAT #
TAT #
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
Incidents
Submitted
CSAT #
TAT #
1
Incidents
Submitted
CSAT #
TAT #
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)