A unique ID for the visualisation, used in the link
Title displayed on top of the application
DB Type
Host
Port
Database
Username
Password
Table

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
Metrics (can be used for size, and to derive colours)
Name Field Aggregation Display format Units
Colours (ratios derived from metrics)
Name Numerator Denominator Display format Units Colour Min Max Stop values Stop points Ignore Outliers%

Additional options »

Max boxes in a treemap. Keep under 200 for speed.
Number of top entries to show in filter dropdown
Report won't be refreshed for this long
Width of the screen. 0 for auto layout.
Total height as a % of width.
Wider boxes (>1) or taller boxes (<1)
Text inside boxes will not exceed this size
Space seperated roles that can view the data
Space seperated roles that can change this page (admin always can)
Instead of colouring calendar by colour metric, use size metric
Colours of the low, medium, high and invalid entries
Show the top X and bottom Y items
Colour theme

Cancel changes