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
test.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Sector
Carrier Flight No
Departure Date
Departure Time
Surge
HYDDEL
6E-308
03-Sep-16
06:05
7999
HYDDEL
6E-308
04-Sep-16
06:05
2713
HYDDEL
6E-308
05-Sep-16
06:05
9593
HYDDEL
6E-308
06-Sep-16
06:05
10089
HYDDEL
6E-308
07-Sep-16
06:05
9951
HYDDEL
6E-308
08-Sep-16
06:05
10319
HYDDEL
6E-308
09-Sep-16
06:05
5470
HYDDEL
6E-308
10-Sep-16
06:05
1412
HYDDEL
6E-308
11-Sep-16
06:05
13718
HYDDEL
6E-308
12-Sep-16
06:05
14039
HYDDEL
6E-308
13-Sep-16
06:05
8899
HYDDEL
6E-308
14-Sep-16
06:05
5389
HYDDEL
6E-308
15-Sep-16
06:05
4580
HYDDEL
6E-308
16-Sep-16
06:05
18566
HYDDEL
6E-308
17-Sep-16
06:05
4521
HYDDEL
6E-308
18-Sep-16
06:05
12665
HYDDEL
6E-308
19-Sep-16
06:05
2228
HYDDEL
6E-308
20-Sep-16
06:05
11518
HYDDEL
6E-308
21-Sep-16
06:05
5130
HYDDEL
6E-308
22-Sep-16
06:05
6606
HYDDEL
6E-308
23-Sep-16
06:05
17710
HYDDEL
6E-308
24-Sep-16
06:05
19625
HYDDEL
6E-308
25-Sep-16
06:05
16324
HYDDEL
6E-308
26-Sep-16
06:05
3700
HYDDEL
6E-308
27-Sep-16
06:05
18878
HYDDEL
6E-308
28-Sep-16
06:05
1276
HYDDEL
6E-308
29-Sep-16
06:05
5592
HYDDEL
6E-308
30-Sep-16
06:05
11203
HYDDEL
6E-308
01-Oct-16
06:05
17146
HYDDEL
6E-308
02-Oct-16
06:05
7076
HYDDEL
6E-308
03-Oct-16
06:05
16574
HYDDEL
6E-308
04-Oct-16
06:05
5025
HYDDEL
6E-308
05-Oct-16
06:05
9113
HYDDEL
6E-308
06-Oct-16
06:05
12954
HYDDEL
6E-308
07-Oct-16
06:05
1663
HYDDEL
6E-308
08-Oct-16
06:05
18358
HYDDEL
6E-308
09-Oct-16
06:05
6140
HYDDEL
6E-308
10-Oct-16
06:05
3980
HYDDEL
6E-308
11-Oct-16
06:05
17074
HYDDEL
6E-308
12-Oct-16
06:05
12663
HYDDEL
6E-308
13-Oct-16
06:05
19363
HYDDEL
6E-308
14-Oct-16
06:05
9462
HYDDEL
6E-308
15-Oct-16
06:05
13900
HYDDEL
6E-308
16-Oct-16
06:05
4997
HYDDEL
6E-308
17-Oct-16
06:05
3225
HYDDEL
6E-308
18-Oct-16
06:05
12805
HYDDEL
6E-308
19-Oct-16
06:05
15989
HYDDEL
6E-308
20-Oct-16
06:05
15924
HYDDEL
6E-308
21-Oct-16
06:05
14479
HYDDEL
6E-308
22-Oct-16
06:05
13970
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
Departure Time
Departure Date
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
Sector
Carrier Flight No
Departure Date
Departure Time
Surge
Filter columns
Sector
Carrier Flight No
Departure Date
Departure Time
Surge
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Sector
Carrier Flight No
Departure Date
Departure Time
Surge
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
Sector
Carrier Flight No
Departure Date
Departure Time
Surge
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
Surge pricing
Flight count
1
Surge pricing
Flight count
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)