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
Apple.xlsx
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Year
Mac
iPod
iPhone
iPad
iTunes
Services
Others
Unnamed: 8
Total
1998
5941
0
0
0
0
0
0
nan
5941
1999
6134
0
0
0
0
0
0
nan
6134
2000
7983
0
0
0
0
0
0
nan
7983
2001
5363
0
0
0
0
0
0
nan
5363
2002
4534
143
0
0
0
1208
0
nan
5885
2003
4491
345
0
0
0
658
1058
nan
6552
2004
4923
1306
0
0
278
821
951
nan
8279
2005
6275
4540
0
0
899
1091
1126
nan
13931
2006
7375
7676
0
0
1885
1279
1100
nan
19315
2007
10314
8305
123
0
2496
1508
1260
nan
24006
2008
14276
9153
1844
0
3340
2207
1659
nan
32479
2009
13859
8091
13033
0
4036
2411
1475
nan
42905
2010
17479
8274
25179
4958
4948
2573
1814
nan
65225
2011
21783
7453
47057
20358
6314
2954
2330
nan
108249
2012
23221
5615
80477
32424
8534
3459
2778
nan
156508
2013
21483
4411
91279
31980
0
16051
5706
nan
170910
2014
24079
2286
101991
30283
0
18063
6093
nan
182795
2015
25471
0
155041
23227
0
19909
10067
nan
233715
2016
22831
0
136700
20628
0
24348
11132
nan
215639
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
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
Year
Mac
iPod
iPhone
iPad
iTunes
Services
Others
Unnamed: 8
Total
Filter columns
Year
Mac
iPod
iPhone
iPad
iTunes
Services
Others
Unnamed: 8
Total
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Year
Mac
iPod
iPhone
iPad
iTunes
Services
Others
Unnamed: 8
Total
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
Year
1
Year
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)