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
pricing.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Region
City
Sector
Company
Category
Volume
Base sales
Discounted sales
North
New Kimberlyfort
Retail
Ewing, Cox and Valenzuela
MHV
1324
176873
172132
East
Schultztown
Retail
Stafford Inc
LCV
410
66611
64266
West
North Nicole
Retail
Arnold Ltd
HT
538
91958
85900
South
Port Brianna
Retail
Goodman-Conner
HT
1630
213331
172337
North
Deniseberg
Retail
Chapman, Glenn and Hale
HT
1066
211115
177535
East
South Frederickmouth
Retail
Barnett-Hanson
LCV
1031
197969
168690
West
West Scott
Retail
Thomas LLC
LCV
461
78275
69289
South
Alisonside
Retail
Hutchinson-Reynolds
MHV
810
118461
99783
North
Davidhaven
Retail
Dawson, Holder and Ray
LCV
1934
289285
286571
East
Port Matthewview
Retail
Paul, Collins and Moreno
HT
106
15697
14813
West
Port Anthony
Retail
Duran-Kirby
LCV
135
16629
15638
South
Jessicamouth
Retail
Gardner, Barnes and Hogan
HT
331
59644
52175
North
Randystad
Retail
Simpson, Hendrix and Mcbride
LCV
436
67813
57257
East
Josephfort
Retail
Edwards, Nolan and Avila
MHV
187
21949
18521
West
Lake Juan
Retail
Martin-Rice
LCV
1227
191272
157931
South
North Zachary
Retail
Young Ltd
MHV
686
112337
102814
North
Wolfland
Retail
Howard Ltd
HT
462
58429
49804
East
Toddville
Retail
King and Sons
LCV
110
16859
14549
West
Brendaland
Retail
Solomon, Peters and Smith
LCV
147
22095
19214
South
Port Haileystad
Retail
Jones and Sons
MHV
907
170202
142912
North
New Kimberlyfort
Manufacturing
Williams, Robinson and Garcia
HT
455
59594
59292
East
Schultztown
Manufacturing
Obrien, Hubbard and Stewart
HT
459
84799
68330
West
North Nicole
Manufacturing
Rogers, Sloan and Solis
MHV
1225
224371
217026
South
Port Brianna
Manufacturing
Thomas, Miller and Allen
LCV
262
41274
40231
North
Deniseberg
Manufacturing
Perez, Bowers and Floyd
MHV
150
17909
16274
East
South Frederickmouth
Manufacturing
Turner, Baker and Cooper
MHV
115
13762
13190
West
West Scott
Manufacturing
Allen-Clark
MHV
543
96650
95195
South
Alisonside
Manufacturing
Baird-Rice
LCV
174
23937
19547
North
Davidhaven
Manufacturing
Shaw, Lee and Casey
LCV
228
33182
32081
East
Port Matthewview
Manufacturing
Torres Inc
MHV
124
22456
18102
West
Port Anthony
Manufacturing
Paul-Adams
LCV
259
27652
27415
South
Jessicamouth
Manufacturing
Simpson Ltd
MHV
326
62534
57950
North
Randystad
Manufacturing
Perez-Edwards
LCV
162
17086
13879
East
Josephfort
Manufacturing
Adams PLC
HT
180
25521
24270
West
Lake Juan
Manufacturing
Taylor LLC
LCV
109
12695
10248
South
North Zachary
Manufacturing
Welch Group
MHV
279
36076
31155
North
Wolfland
Manufacturing
Osborn Group
MHV
2004
312849
301519
East
Toddville
Manufacturing
Bray-Pearson
LCV
225
43800
41361
West
Brendaland
Manufacturing
Bray-Terry
LCV
705
122625
114032
South
Port Haileystad
Manufacturing
Humphrey-Stuart
MHV
1005
142609
137671
North
New Kimberlyfort
Banking
Ewing, Cox and Valenzuela
MHV
597
95366
79538
East
Schultztown
Banking
Stafford Inc
HT
117
15983
13883
West
North Nicole
Banking
Arnold Ltd
MHV
1067
191959
181237
South
Port Brianna
Banking
Goodman-Conner
HT
1557
282633
231044
North
Deniseberg
Banking
Chapman, Glenn and Hale
LCV
319
59373
54990
East
South Frederickmouth
Banking
Barnett-Hanson
LCV
772
135355
115622
West
West Scott
Banking
Thomas LLC
MHV
1786
188653
171394
South
Alisonside
Banking
Hutchinson-Reynolds
LCV
179
23251
20297
North
Davidhaven
Banking
Dawson, Holder and Ray
LCV
1450
196302
164174
East
Port Matthewview
Banking
Paul, Collins and Moreno
LCV
770
141061
134893
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
Region
City
Sector
Company
Category
Volume
Base sales
Discounted sales
Filter columns
Region
Sector
Category
City
Company
Volume
Base sales
Discounted sales
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Region
City
Sector
Company
Category
Volume
Base sales
Discounted sales
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
Region
City
Sector
Company
Category
Volume
Base sales
Discounted sales
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
Region
City
Sector
Company
Category
Volume
Base sales
Discounted sales
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
Sales
Discounted sales
Volume
1
Sales
Discounted sales
Volume
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
Sales
Discounted sales
Volume
1
Sales
Discounted sales
Volume
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
Sales
Discounted sales
Volume
1
Sales
Discounted sales
Volume
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)