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
WA_Retail-SalesMarketing_-ProfitCost (2).csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Telephone
United States
437477.15
158371.76
66385
2.55285714
6.59
156672.57
5.19571429
344917.493142
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Telephone
Canada
14313.48
6298.8
2172
2.9
6.59
7145.88
6.19
13444.68
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Telephone
Austria
85399.81
32490.25
12959
2.6975
6.59
34689.14
5.75
74514.25
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
United States
222735.41
88348.13
33799
2.72
6.59
92939.6
5.65222222
191039.458814
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Mexico
169942.92
65215.05
25788
2.72
6.59
68402.21
5.72333333
147593.319914
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Finland
78361.69
34483.9
11891
2.9
6.59
38407.93
6.13
72891.83
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Denmark
13127.28
5776.8
1992
2.9
6.59
6693.12
6.26
12469.92
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
France
114692.36
46306.58
17404
2.765
6.59
49702.57
5.80833333
101088.233275
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Germany
169692.5
66847.97
25750
2.72
6.59
70754.31
5.69444444
146631.94433
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
United Kingdom
12250.81
5391.1
1859
2.9
6.59
6246.24
6.26
11637.34
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Belgium
13245.9
5829.0
2010
2.9
6.59
7014.9
6.39
12843.9
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Italy
131865.9
50526.78
20010
2.66857143
6.59
52562.55
5.55142857
111084.085686
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Sales visit
Spain
13878.54
6107.4
2106
2.9
6.59
6928.74
6.19
13036.14
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
United States
407123.61
164590.44
61779
2.7785
6.59
176276.82
5.838
360665.802
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
Canada
171649.73
67560.23
26047
2.72
6.59
71425.99
5.68666667
148120.606753
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
Mexico
33964.86
10771.86
5154
2.09
6.59
9586.44
3.95
20358.3
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
Austria
45022.88
17574.77
6832
2.6975
6.59
18987.98
5.7175
39061.96
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
Italy
13707.2
6032.0
2080
2.9
6.59
6843.2
6.19
12875.2
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Web
Spain
127219.95
51868.89
19305
2.79875
6.59
56499.2
5.9275
114430.3875
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Special
Canada
40337.39
17750.9
6121
2.9
6.59
20260.66
6.21333333
38031.8133129
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Special
Mexico
27842.75
12252.5
4225
2.9
6.59
13900.25
6.19
26152.75
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Special
Japan
14089.42
6200.2
2138
2.9
6.59
7034.02
6.19
13234.22
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Special
China
30314.0
13340.0
4600
2.9
6.59
14858.0
6.13
28198.0
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Special
Belgium
5660.81
2491.1
859
2.9
6.59
2997.91
6.39
5489.01
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
United States
68628.26
24392.09
10414
2.495
6.59
23812.95
5.04
52486.56
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
Japan
14781.37
6504.7
2243
2.9
6.59
7379.47
6.19
13884.17
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
Korea
22478.49
9891.9
3411
2.9
6.59
11017.53
6.13
20909.43
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
Netherlands
31019.13
9837.63
4707
2.09
6.59
8755.02
3.95
18592.65
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
France
56726.72
21169.16
8608
2.63
6.59
21740.5
5.46666667
47057.0666954
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Mail
Spain
23374.73
7413.23
3547
2.09
6.59
6597.42
3.95
14010.65
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Canada
168769.9
70010.02
25610
2.82636364
6.59
77255.4
6.01181818
153962.66359
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Japan
91521.92
35412.77
13888
2.6975
6.59
36768.95
5.6
77772.8
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Netherlands
17035.15
7496.5
2585
2.9
6.59
8349.55
6.13
15846.05
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Sweden
13634.71
6000.1
2069
2.9
6.59
6807.01
6.19
12807.11
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Germany
188539.9
66575.41
28610
2.495
6.59
65054.23
5.06375
144873.8875
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Italy
73445.55
27959.46
11145
2.6975
6.59
29225.74
5.665
63136.425
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
E-mail
Spain
39902.45
13998.74
6055
2.495
6.59
13750.8
5.105
30910.775
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
United States
50011.51
22008.1
7589
2.9
6.59
24737.63
6.17333333
46849.4266414
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
Brazil
36001.17
15842.7
5463
2.9
6.59
18208.4
6.23666667
34070.9100182
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
Japan
76364.92
29283.85
11588
2.6975
6.59
30764.41
5.665
65646.02
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
Singapore
104853.49
46141.9
15911
2.9
6.59
51392.53
6.13
97534.43
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
France
41839.91
18412.1
6349
2.9
6.59
20976.05
6.21666667
39469.6166878
2004
Camping Equipment
Cooking Gear
TrailChef Water Bag
Fax
Germany
14399.15
6336.5
2185
2.9
6.59
7188.65
6.19
13525.15
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
United States
235238.22
124283.88
18774
6.62
12.53
85308.18
11.427
214530.498
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
Canada
12129.04
6408.16
968
6.62
12.53
2081.2
8.77
8489.36
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
Mexico
17090.92
9029.68
1364
6.62
12.53
2932.6
8.77
11962.28
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
Brazil
11314.59
5977.86
903
6.62
12.53
1941.45
8.77
7919.31
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
Japan
124485.55
65769.7
9935
6.62
12.53
42189.47
11.28692308
112135.5808
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
China
55219.71
29174.34
4407
6.62
12.53
16843.07
10.85666667
47845.3300147
2004
Camping Equipment
Cooking Gear
TrailChef Canteen
Telephone
Netherlands
25448.43
13445.22
2031
6.62
12.53
10987.71
12.03
24432.93
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
Product Line
Product Type
Product
Order Method
Retailer Country
Year
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
Filter columns
Product Line
Product Type
Product
Order Method
Retailer Country
Year
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Year
Product Line
Product Type
Product
Order Method
Retailer Country
Planned Revenue
Product Cost
Quantity
Unit Cost
Unit price
Gross profit
Unit sale price
Sales Revenue
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
Product Line
Revenue
Profit
Product Type
Product Order Method
Product
1
Product Line
Revenue
Profit
Product Type
Product Order Method
Product
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
Product Line
Revenue
Profit
Product Type
Product Order Method
Product
1
Product Line
Revenue
Profit
Product Type
Product Order Method
Product
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)