Your search did not match any results.
PivotGrid

Field Chooser

Documentation
The PivotGrid ships with a fully integrated field chooser. It can be invoked using the PivotGrid’s built-in context menu. In this demo, the field chooser is always displayed near the PivotGrid (the PivotGridFieldChooser widget is connected to the PivotGrid’s data source and added to the page).
Copy to CodePen
Apply
Reset
window.onload = function() { var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({ fields: [{ caption: "Region", width: 120, dataField: "region", area: "row" }, { caption: "City", dataField: "city", width: 150, area: "row", selector: function(data) { return data.city + " (" + data.country + ")"; } }, { dataField: "date", dataType: "date", area: "column" }, { caption: "Sales", dataField: "amount", dataType: "number", summaryType: "sum", format: "currency", area: "data" }], store: sales }), layout = ko.observable(0); var viewModel = { pivotGridOptions: { allowSortingBySummary: true, allowSorting: true, allowFiltering: true, showBorders: true, dataSource: pivotGridDataSource, fieldChooser: { enabled: false } }, fieldChooserOptions: { dataSource: pivotGridDataSource, texts: { allFields: "All", columnFields: "Columns", dataFields: "Data", rowFields: "Rows", filterFields: "Filter" }, width: 400, height: 400, layout: layout }, layoutsOptions: { items: layouts, layout: "vertical", valueExpr: "key", displayExpr: "name", value: layout } }; ko.applyBindings(viewModel, document.getElementById("pivotgrid")); };
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <script src="js/jquery-3.1.0.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/knockout/3.4.0/knockout-min.js"></script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/17.1.6/css/dx.spa.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/17.1.6/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/17.1.6/css/dx.light.css" /> <script src="https://cdn3.devexpress.com/jslib/17.1.6/js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type ="text/css" href ="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="pivotgrid"> <div data-bind="dxPivotGrid: pivotGridOptions"></div> <div class="container"> <div data-bind="dxPivotGridFieldChooser: fieldChooserOptions"></div> <div class="options"> <div class="caption">Options</div> <div class="option"> <span>Choose layout:</span> <div id="layouts" data-bind="dxRadioGroup: layoutsOptions"></div> </div> </div> </div> </div> </div> </body> </html>
.container { position: relative; margin-top: 20px; } .options { padding: 20px; background-color: #f5f5f5; position: absolute; top: 29px; bottom: 5px; left: 420px; width: 180px; } .caption { font-size: 18px; font-weight: 500; } .option { margin-top: 10px; }
var sales = [{ "orderId": 1, "region": "North America", "country": "USA", "city": "New York", "amount": 1740, "date": "2013/01/06" }, { "orderId": 2, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 850, "date": "2013/01/13" }, { "orderId": 3, "region": "North America", "country": "USA", "city": "Denver", "amount": 2235, "date": "2013/01/07" }, { "orderId": 4, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1965, "date": "2013/01/03" }, { "orderId": 5, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 880, "date": "2013/01/10" }, { "orderId": 6, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5260, "date": "2013/01/17" }, { "orderId": 7, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2790, "date": "2013/01/21" }, { "orderId": 8, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 3140, "date": "2013/01/01" }, { "orderId": 9, "region": "Europe", "country": "GBR", "city": "London", "amount": 6175, "date": "2013/01/24" }, { "orderId": 10, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4575, "date": "2013/01/11" }, { "orderId": 11, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3680, "date": "2013/01/12" }, { "orderId": 12, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2260, "date": "2013/01/01" }, { "orderId": 13, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2910, "date": "2013/01/26" }, { "orderId": 14, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 8400, "date": "2013/01/05" }, { "orderId": 15, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 1325, "date": "2013/01/14" }, { "orderId": 16, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3920, "date": "2013/01/05" }, { "orderId": 17, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2220, "date": "2013/01/15" }, { "orderId": 18, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 940, "date": "2013/01/01" }, { "orderId": 19, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1630, "date": "2013/01/10" }, { "orderId": 20, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2910, "date": "2013/01/23" }, { "orderId": 21, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2600, "date": "2013/01/14" }, { "orderId": 22, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4340, "date": "2013/01/26" }, { "orderId": 23, "region": "Europe", "country": "GBR", "city": "London", "amount": 6650, "date": "2013/01/24" }, { "orderId": 24, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 490, "date": "2013/01/22" }, { "orderId": 25, "region": "North America", "country": "USA", "city": "New York", "amount": 3390, "date": "2013/01/25" }, { "orderId": 26, "region": "North America", "country": "USA", "city": "New York", "amount": 5160, "date": "2013/02/20" }, { "orderId": 27, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5750, "date": "2013/02/12" }, { "orderId": 28, "region": "North America", "country": "USA", "city": "Denver", "amount": 2805, "date": "2013/02/13" }, { "orderId": 29, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2505, "date": "2013/02/09" }, { "orderId": 30, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 930, "date": "2013/02/04" }, { "orderId": 31, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1240, "date": "2013/02/03" }, { "orderId": 32, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 315, "date": "2013/02/04" }, { "orderId": 33, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2870, "date": "2013/02/18" }, { "orderId": 34, "region": "Europe", "country": "GBR", "city": "London", "amount": 5150, "date": "2013/02/18" }, { "orderId": 35, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 2725, "date": "2013/02/20" }, { "orderId": 36, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2840, "date": "2013/02/04" }, { "orderId": 37, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5840, "date": "2013/02/13" }, { "orderId": 38, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6750, "date": "2013/02/11" }, { "orderId": 39, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1200, "date": "2013/02/03" }, { "orderId": 40, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4550, "date": "2013/02/08" }, { "orderId": 41, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 6040, "date": "2013/02/17" }, { "orderId": 42, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2205, "date": "2013/02/08" }, { "orderId": 43, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 990, "date": "2013/02/20" }, { "orderId": 44, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 700, "date": "2013/02/11" }, { "orderId": 45, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2325, "date": "2013/02/15" }, { "orderId": 46, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 930, "date": "2013/02/21" }, { "orderId": 47, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1560, "date": "2013/02/04" }, { "orderId": 48, "region": "North America", "country": "USA", "city": "New York", "amount": 1740, "date": "2013/03/04" }, { "orderId": 49, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3575, "date": "2013/03/20" }, { "orderId": 50, "region": "North America", "country": "USA", "city": "Denver", "amount": 4500, "date": "2013/03/04" }, { "orderId": 51, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1605, "date": "2013/03/17" }, { "orderId": 52, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 800, "date": "2013/03/21" }, { "orderId": 53, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 640, "date": "2013/03/08" }, { "orderId": 54, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 735, "date": "2013/03/19" }, { "orderId": 55, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2520, "date": "2013/03/20" }, { "orderId": 56, "region": "Europe", "country": "GBR", "city": "London", "amount": 6675, "date": "2013/03/18" }, { "orderId": 57, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3625, "date": "2013/03/25" }, { "orderId": 58, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1200, "date": "2013/03/07" }, { "orderId": 59, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2000, "date": "2013/03/07" }, { "orderId": 60, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1410, "date": "2013/03/10" }, { "orderId": 61, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2700, "date": "2013/03/19" }, { "orderId": 62, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5950, "date": "2013/03/24" }, { "orderId": 63, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5120, "date": "2013/03/08" }, { "orderId": 64, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2013/03/17" }, { "orderId": 65, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1110, "date": "2013/03/08" }, { "orderId": 66, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 980, "date": "2013/03/21" }, { "orderId": 67, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5460, "date": "2013/03/19" }, { "orderId": 68, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3800, "date": "2013/03/12" }, { "orderId": 69, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2610, "date": "2013/03/04" }, { "orderId": 70, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3080, "date": "2013/03/22" }, { "orderId": 71, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2010, "date": "2013/03/23" }, { "orderId": 72, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1200, "date": "2013/03/04" }, { "orderId": 73, "region": "North America", "country": "USA", "city": "New York", "amount": 7680, "date": "2013/04/15" }, { "orderId": 74, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1325, "date": "2013/04/07" }, { "orderId": 75, "region": "North America", "country": "USA", "city": "Denver", "amount": 2835, "date": "2013/04/10" }, { "orderId": 76, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3660, "date": "2013/04/10" }, { "orderId": 77, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 390, "date": "2013/04/12" }, { "orderId": 78, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4420, "date": "2013/04/08" }, { "orderId": 79, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1755, "date": "2013/04/13" }, { "orderId": 80, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2580, "date": "2013/04/15" }, { "orderId": 81, "region": "Europe", "country": "GBR", "city": "London", "amount": 850, "date": "2013/04/01" }, { "orderId": 82, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 2825, "date": "2013/04/10" }, { "orderId": 83, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 540, "date": "2013/04/06" }, { "orderId": 84, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1520, "date": "2013/04/08" }, { "orderId": 85, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8760, "date": "2013/04/26" }, { "orderId": 86, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1110, "date": "2013/04/16" }, { "orderId": 87, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6850, "date": "2013/04/19" }, { "orderId": 88, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1940, "date": "2013/04/23" }, { "orderId": 89, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2013/04/21" }, { "orderId": 90, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 3090, "date": "2013/04/03" }, { "orderId": 91, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1640, "date": "2013/04/24" }, { "orderId": 92, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3585, "date": "2013/04/01" }, { "orderId": 93, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1770, "date": "2013/04/01" }, { "orderId": 94, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4005, "date": "2013/04/04" }, { "orderId": 95, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2870, "date": "2013/04/02" }, { "orderId": 96, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 960, "date": "2013/04/20" }, { "orderId": 97, "region": "North America", "country": "USA", "city": "New York", "amount": 8640, "date": "2013/05/14" }, { "orderId": 98, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5450, "date": "2013/05/24" }, { "orderId": 99, "region": "North America", "country": "USA", "city": "Denver", "amount": 2535, "date": "2013/05/07" }, { "orderId": 100, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1155, "date": "2013/05/20" }, { "orderId": 101, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3140, "date": "2013/05/18" }, { "orderId": 102, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2260, "date": "2013/05/19" }, { "orderId": 103, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1215, "date": "2013/05/23" }, { "orderId": 104, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1210, "date": "2013/05/08" }, { "orderId": 105, "region": "Europe", "country": "GBR", "city": "London", "amount": 875, "date": "2013/05/25" }, { "orderId": 106, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5400, "date": "2013/05/03" }, { "orderId": 107, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5940, "date": "2013/05/25" }, { "orderId": 108, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4700, "date": "2013/05/03" }, { "orderId": 109, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5520, "date": "2013/05/12" }, { "orderId": 110, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9210, "date": "2013/05/22" }, { "orderId": 111, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7950, "date": "2013/05/12" }, { "orderId": 112, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3740, "date": "2013/05/24" }, { "orderId": 113, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 990, "date": "2013/05/02" }, { "orderId": 114, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 3190, "date": "2013/05/03" }, { "orderId": 115, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2430, "date": "2013/05/11" }, { "orderId": 116, "region": "North America", "country": "USA", "city": "New York", "amount": 7380, "date": "2013/06/15" }, { "orderId": 117, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4475, "date": "2013/06/08" }, { "orderId": 118, "region": "North America", "country": "USA", "city": "Denver", "amount": 1290, "date": "2013/06/10" }, { "orderId": 119, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2250, "date": "2013/06/10" }, { "orderId": 120, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 350, "date": "2013/06/22" }, { "orderId": 121, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5480, "date": "2013/06/24" }, { "orderId": 122, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2355, "date": "2013/06/10" }, { "orderId": 123, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1960, "date": "2013/06/23" }, { "orderId": 124, "region": "Europe", "country": "GBR", "city": "London", "amount": 4125, "date": "2013/06/06" }, { "orderId": 125, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7925, "date": "2013/06/12" }, { "orderId": 126, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1120, "date": "2013/06/22" }, { "orderId": 127, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5100, "date": "2013/06/01" }, { "orderId": 128, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1500, "date": "2013/06/25" }, { "orderId": 129, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5130, "date": "2013/06/10" }, { "orderId": 130, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2475, "date": "2013/06/10" }, { "orderId": 131, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2100, "date": "2013/06/06" }, { "orderId": 132, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3570, "date": "2013/06/10" }, { "orderId": 133, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 550, "date": "2013/06/02" }, { "orderId": 134, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2850, "date": "2013/06/26" }, { "orderId": 135, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4280, "date": "2013/06/19" }, { "orderId": 136, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1460, "date": "2013/06/17" }, { "orderId": 137, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 960, "date": "2013/06/17" }, { "orderId": 138, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1520, "date": "2013/06/03" }, { "orderId": 139, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 6750, "date": "2013/06/21" }, { "orderId": 140, "region": "North America", "country": "USA", "city": "New York", "amount": 7260, "date": "2013/07/14" }, { "orderId": 141, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2450, "date": "2013/07/11" }, { "orderId": 142, "region": "North America", "country": "USA", "city": "Denver", "amount": 3540, "date": "2013/07/02" }, { "orderId": 143, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1950, "date": "2013/07/03" }, { "orderId": 144, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 360, "date": "2013/07/07" }, { "orderId": 145, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4500, "date": "2013/07/03" }, { "orderId": 146, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4575, "date": "2013/07/21" }, { "orderId": 147, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2310, "date": "2013/07/18" }, { "orderId": 148, "region": "Europe", "country": "GBR", "city": "London", "amount": 7500, "date": "2013/07/04" }, { "orderId": 149, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3575, "date": "2013/07/23" }, { "orderId": 150, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 760, "date": "2013/07/01" }, { "orderId": 151, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2400, "date": "2013/07/11" }, { "orderId": 152, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 3330, "date": "2013/07/04" }, { "orderId": 153, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3480, "date": "2013/07/23" }, { "orderId": 154, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4875, "date": "2013/07/11" }, { "orderId": 155, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4980, "date": "2013/07/19" }, { "orderId": 156, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2580, "date": "2013/07/04" }, { "orderId": 157, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2650, "date": "2013/07/16" }, { "orderId": 158, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1190, "date": "2013/07/02" }, { "orderId": 159, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 960, "date": "2013/07/26" }, { "orderId": 160, "region": "North America", "country": "USA", "city": "New York", "amount": 3600, "date": "2013/08/08" }, { "orderId": 161, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2250, "date": "2013/08/01" }, { "orderId": 162, "region": "North America", "country": "USA", "city": "Denver", "amount": 1275, "date": "2013/08/02" }, { "orderId": 163, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3885, "date": "2013/08/14" }, { "orderId": 164, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1900, "date": "2013/08/05" }, { "orderId": 165, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2300, "date": "2013/08/09" }, { "orderId": 166, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2895, "date": "2013/08/15" }, { "orderId": 167, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 350, "date": "2013/08/20" }, { "orderId": 168, "region": "Europe", "country": "GBR", "city": "London", "amount": 4200, "date": "2013/08/22" }, { "orderId": 169, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7175, "date": "2013/08/14" }, { "orderId": 170, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4420, "date": "2013/08/24" }, { "orderId": 171, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5200, "date": "2013/08/21" }, { "orderId": 172, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7920, "date": "2013/08/17" }, { "orderId": 173, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 6990, "date": "2013/08/22" }, { "orderId": 174, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2125, "date": "2013/08/05" }, { "orderId": 175, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2220, "date": "2013/08/16" }, { "orderId": 176, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1575, "date": "2013/08/23" }, { "orderId": 177, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1880, "date": "2013/08/12" }, { "orderId": 178, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 710, "date": "2013/08/25" }, { "orderId": 179, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 390, "date": "2013/08/20" }, { "orderId": 180, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4635, "date": "2013/08/04" }, { "orderId": 181, "region": "North America", "country": "USA", "city": "Denver", "amount": 4350, "date": "2013/08/19" }, { "orderId": 182, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 6020, "date": "2013/08/02" }, { "orderId": 183, "region": "North America", "country": "USA", "city": "New York", "amount": 3660, "date": "2013/08/19" }, { "orderId": 184, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2013/08/24" }, { "orderId": 185, "region": "North America", "country": "USA", "city": "New York", "amount": 4410, "date": "2013/09/12" }, { "orderId": 186, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1725, "date": "2013/09/07" }, { "orderId": 187, "region": "North America", "country": "USA", "city": "Denver", "amount": 2715, "date": "2013/09/14" }, { "orderId": 188, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2820, "date": "2013/09/08" }, { "orderId": 189, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2310, "date": "2013/09/12" }, { "orderId": 190, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 780, "date": "2013/09/08" }, { "orderId": 191, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2370, "date": "2013/09/19" }, { "orderId": 192, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1410, "date": "2013/09/09" }, { "orderId": 193, "region": "Europe", "country": "GBR", "city": "London", "amount": 1825, "date": "2013/09/23" }, { "orderId": 194, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4075, "date": "2013/09/06" }, { "orderId": 195, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1020, "date": "2013/09/04" }, { "orderId": 196, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4320, "date": "2013/09/25" }, { "orderId": 197, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7530, "date": "2013/09/13" }, { "orderId": 198, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2820, "date": "2013/09/08" }, { "orderId": 199, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3050, "date": "2013/09/04" }, { "orderId": 200, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5080, "date": "2013/09/25" }, { "orderId": 201, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1125, "date": "2013/09/13" }, { "orderId": 202, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 850, "date": "2013/09/24" }, { "orderId": 203, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1440, "date": "2013/09/19" }, { "orderId": 204, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1950, "date": "2013/09/02" }, { "orderId": 205, "region": "North America", "country": "USA", "city": "New York", "amount": 6390, "date": "2013/10/11" }, { "orderId": 206, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4625, "date": "2013/10/02" }, { "orderId": 207, "region": "North America", "country": "USA", "city": "Denver", "amount": 3510, "date": "2013/10/24" }, { "orderId": 208, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2730, "date": "2013/10/15" }, { "orderId": 209, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2070, "date": "2013/10/15" }, { "orderId": 210, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2320, "date": "2013/10/18" }, { "orderId": 211, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4260, "date": "2013/10/24" }, { "orderId": 212, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 840, "date": "2013/10/18" }, { "orderId": 213, "region": "Europe", "country": "GBR", "city": "London", "amount": 7300, "date": "2013/10/24" }, { "orderId": 214, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5950, "date": "2013/10/11" }, { "orderId": 215, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3220, "date": "2013/10/25" }, { "orderId": 216, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3480, "date": "2013/10/08" }, { "orderId": 217, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 4830, "date": "2013/10/26" }, { "orderId": 218, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4470, "date": "2013/10/05" }, { "orderId": 219, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3675, "date": "2013/10/23" }, { "orderId": 220, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4260, "date": "2013/10/01" }, { "orderId": 221, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4245, "date": "2013/10/26" }, { "orderId": 222, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1470, "date": "2013/10/01" }, { "orderId": 223, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1810, "date": "2013/10/02" }, { "orderId": 224, "region": "North America", "country": "USA", "city": "New York", "amount": 600, "date": "2013/10/23" }, { "orderId": 225, "region": "North America", "country": "USA", "city": "New York", "amount": 7500, "date": "2013/11/03" }, { "orderId": 226, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4625, "date": "2013/11/02" }, { "orderId": 227, "region": "North America", "country": "USA", "city": "Denver", "amount": 2625, "date": "2013/11/09" }, { "orderId": 228, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1440, "date": "2013/11/15" }, { "orderId": 229, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2420, "date": "2013/11/15" }, { "orderId": 230, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4180, "date": "2013/11/15" }, { "orderId": 231, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3720, "date": "2013/11/25" }, { "orderId": 232, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2730, "date": "2013/11/08" }, { "orderId": 233, "region": "Europe", "country": "GBR", "city": "London", "amount": 3775, "date": "2013/11/17" }, { "orderId": 234, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3525, "date": "2013/11/15" }, { "orderId": 235, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5320, "date": "2013/11/08" }, { "orderId": 236, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5340, "date": "2013/11/13" }, { "orderId": 237, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8850, "date": "2013/11/01" }, { "orderId": 238, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 7050, "date": "2013/11/14" }, { "orderId": 239, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4200, "date": "2013/11/18" }, { "orderId": 240, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4960, "date": "2013/11/04" }, { "orderId": 241, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2280, "date": "2013/11/13" }, { "orderId": 242, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 590, "date": "2013/11/11" }, { "orderId": 243, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 810, "date": "2013/11/12" }, { "orderId": 244, "region": "Europe", "country": "GBR", "city": "London", "amount": 2625, "date": "2013/11/07" }, { "orderId": 245, "region": "North America", "country": "USA", "city": "New York", "amount": 8280, "date": "2013/12/01" }, { "orderId": 246, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5650, "date": "2013/12/19" }, { "orderId": 247, "region": "North America", "country": "USA", "city": "Denver", "amount": 2760, "date": "2013/12/14" }, { "orderId": 248, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2670, "date": "2013/12/03" }, { "orderId": 249, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2520, "date": "2013/12/20" }, { "orderId": 250, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4080, "date": "2013/12/21" }, { "orderId": 251, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4140, "date": "2013/12/22" }, { "orderId": 252, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 390, "date": "2013/12/04" }, { "orderId": 253, "region": "Europe", "country": "GBR", "city": "London", "amount": 1400, "date": "2013/12/19" }, { "orderId": 254, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7275, "date": "2013/12/22" }, { "orderId": 255, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4100, "date": "2013/12/20" }, { "orderId": 256, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5520, "date": "2013/12/25" }, { "orderId": 257, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 9210, "date": "2013/12/24" }, { "orderId": 258, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 7290, "date": "2013/12/05" }, { "orderId": 259, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 625, "date": "2013/12/22" }, { "orderId": 260, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4460, "date": "2013/12/12" }, { "orderId": 261, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3825, "date": "2013/12/13" }, { "orderId": 262, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2850, "date": "2013/12/17" }, { "orderId": 263, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2780, "date": "2013/12/07" }, { "orderId": 264, "region": "North America", "country": "USA", "city": "New York", "amount": 840, "date": "2013/12/18" }, { "orderId": 265, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2970, "date": "2013/12/23" }, { "orderId": 266, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 945, "date": "2013/12/06" }, { "orderId": 267, "region": "North America", "country": "USA", "city": "Denver", "amount": 2625, "date": "2013/12/04" }, { "orderId": 268, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 390, "date": "2013/12/01" }, { "orderId": 269, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2250, "date": "2013/12/02" }, { "orderId": 270, "region": "North America", "country": "USA", "city": "New York", "amount": 7710, "date": "2014/01/18" }, { "orderId": 271, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7975, "date": "2014/01/10" }, { "orderId": 272, "region": "North America", "country": "USA", "city": "Denver", "amount": 3285, "date": "2014/01/13" }, { "orderId": 273, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2580, "date": "2014/01/22" }, { "orderId": 274, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2160, "date": "2014/01/26" }, { "orderId": 275, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1100, "date": "2014/01/25" }, { "orderId": 276, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4425, "date": "2014/01/21" }, { "orderId": 277, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1360, "date": "2014/01/22" }, { "orderId": 278, "region": "Europe", "country": "GBR", "city": "London", "amount": 3250, "date": "2014/01/14" }, { "orderId": 279, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5550, "date": "2014/01/21" }, { "orderId": 280, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2860, "date": "2014/01/25" }, { "orderId": 281, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5320, "date": "2014/01/08" }, { "orderId": 282, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 4050, "date": "2014/01/14" }, { "orderId": 283, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3450, "date": "2014/01/24" }, { "orderId": 284, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5425, "date": "2014/01/11" }, { "orderId": 285, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4860, "date": "2014/01/12" }, { "orderId": 286, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4695, "date": "2014/01/16" }, { "orderId": 287, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 610, "date": "2014/01/05" }, { "orderId": 288, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1580, "date": "2014/01/15" }, { "orderId": 289, "region": "North America", "country": "USA", "city": "New York", "amount": 3780, "date": "2014/02/18" }, { "orderId": 290, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5400, "date": "2014/02/21" }, { "orderId": 291, "region": "North America", "country": "USA", "city": "Denver", "amount": 630, "date": "2014/02/18" }, { "orderId": 292, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3960, "date": "2014/02/04" }, { "orderId": 293, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2010, "date": "2014/02/25" }, { "orderId": 294, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5000, "date": "2014/02/01" }, { "orderId": 295, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1995, "date": "2014/02/20" }, { "orderId": 296, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 860, "date": "2014/02/12" }, { "orderId": 297, "region": "Europe", "country": "GBR", "city": "London", "amount": 2150, "date": "2014/02/10" }, { "orderId": 298, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4050, "date": "2014/02/06" }, { "orderId": 299, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2960, "date": "2014/02/18" }, { "orderId": 300, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1780, "date": "2014/02/26" }, { "orderId": 301, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8700, "date": "2014/02/03" }, { "orderId": 302, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3390, "date": "2014/02/03" }, { "orderId": 303, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4425, "date": "2014/02/15" }, { "orderId": 304, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1180, "date": "2014/02/23" }, { "orderId": 305, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 360, "date": "2014/02/08" }, { "orderId": 306, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2310, "date": "2014/02/13" }, { "orderId": 307, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1770, "date": "2014/02/20" }, { "orderId": 308, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3060, "date": "2014/02/26" }, { "orderId": 309, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1750, "date": "2014/02/12" }, { "orderId": 310, "region": "North America", "country": "USA", "city": "New York", "amount": 2280, "date": "2014/03/09" }, { "orderId": 311, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7600, "date": "2014/03/25" }, { "orderId": 312, "region": "North America", "country": "USA", "city": "Denver", "amount": 1035, "date": "2014/03/23" }, { "orderId": 313, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1245, "date": "2014/03/01" }, { "orderId": 314, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2860, "date": "2014/03/19" }, { "orderId": 315, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 440, "date": "2014/03/19" }, { "orderId": 316, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4665, "date": "2014/03/02" }, { "orderId": 317, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2270, "date": "2014/03/15" }, { "orderId": 318, "region": "Europe", "country": "GBR", "city": "London", "amount": 5000, "date": "2014/03/09" }, { "orderId": 319, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5100, "date": "2014/03/23" }, { "orderId": 320, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2120, "date": "2014/03/11" }, { "orderId": 321, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5140, "date": "2014/03/05" }, { "orderId": 322, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6210, "date": "2014/03/19" }, { "orderId": 323, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9510, "date": "2014/03/19" }, { "orderId": 324, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7600, "date": "2014/03/21" }, { "orderId": 325, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5420, "date": "2014/03/15" }, { "orderId": 326, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2014/03/05" }, { "orderId": 327, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1820, "date": "2014/03/07" }, { "orderId": 328, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1670, "date": "2014/03/21" }, { "orderId": 329, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4800, "date": "2014/03/08" }, { "orderId": 330, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2925, "date": "2014/03/03" }, { "orderId": 331, "region": "North America", "country": "USA", "city": "New York", "amount": 2940, "date": "2014/04/11" }, { "orderId": 332, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3525, "date": "2014/04/13" }, { "orderId": 333, "region": "North America", "country": "USA", "city": "Denver", "amount": 2475, "date": "2014/04/22" }, { "orderId": 334, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3315, "date": "2014/04/08" }, { "orderId": 335, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3140, "date": "2014/04/07" }, { "orderId": 336, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2520, "date": "2014/04/01" }, { "orderId": 337, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1200, "date": "2014/04/10" }, { "orderId": 338, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2060, "date": "2014/04/21" }, { "orderId": 339, "region": "Europe", "country": "GBR", "city": "London", "amount": 7875, "date": "2014/04/02" }, { "orderId": 340, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1450, "date": "2014/04/07" }, { "orderId": 341, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2640, "date": "2014/04/22" }, { "orderId": 342, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1960, "date": "2014/04/16" }, { "orderId": 343, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2250, "date": "2014/04/23" }, { "orderId": 344, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4500, "date": "2014/04/05" }, { "orderId": 345, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5050, "date": "2014/04/11" }, { "orderId": 346, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2940, "date": "2014/04/02" }, { "orderId": 347, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2880, "date": "2014/04/14" }, { "orderId": 348, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1050, "date": "2014/04/19" }, { "orderId": 349, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1850, "date": "2014/04/02" }, { "orderId": 350, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3160, "date": "2014/04/01" }, { "orderId": 351, "region": "Europe", "country": "GBR", "city": "London", "amount": 875, "date": "2014/04/04" }, { "orderId": 352, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3200, "date": "2014/04/08" }, { "orderId": 353, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1380, "date": "2014/04/21" }, { "orderId": 354, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3060, "date": "2014/04/06" }, { "orderId": 355, "region": "North America", "country": "USA", "city": "New York", "amount": 6690, "date": "2014/05/19" }, { "orderId": 356, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2014/05/15" }, { "orderId": 357, "region": "North America", "country": "USA", "city": "Denver", "amount": 4665, "date": "2014/05/10" }, { "orderId": 358, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4530, "date": "2014/05/18" }, { "orderId": 359, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1330, "date": "2014/05/08" }, { "orderId": 360, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1720, "date": "2014/05/20" }, { "orderId": 361, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3750, "date": "2014/05/16" }, { "orderId": 362, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1290, "date": "2014/05/10" }, { "orderId": 363, "region": "Europe", "country": "GBR", "city": "London", "amount": 4925, "date": "2014/05/14" }, { "orderId": 364, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4300, "date": "2014/05/22" }, { "orderId": 365, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5740, "date": "2014/05/08" }, { "orderId": 366, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3760, "date": "2014/05/18" }, { "orderId": 367, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7920, "date": "2014/05/22" }, { "orderId": 368, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1440, "date": "2014/05/21" }, { "orderId": 369, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5975, "date": "2014/05/25" }, { "orderId": 370, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4440, "date": "2014/05/05" }, { "orderId": 371, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2310, "date": "2014/05/24" }, { "orderId": 372, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2250, "date": "2014/05/06" }, { "orderId": 373, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2320, "date": "2014/05/14" }, { "orderId": 374, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8370, "date": "2014/05/06" }, { "orderId": 375, "region": "North America", "country": "USA", "city": "New York", "amount": 5190, "date": "2014/06/26" }, { "orderId": 376, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 925, "date": "2014/06/04" }, { "orderId": 377, "region": "North America", "country": "USA", "city": "Denver", "amount": 3240, "date": "2014/06/20" }, { "orderId": 378, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3180, "date": "2014/06/23" }, { "orderId": 379, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 780, "date": "2014/06/13" }, { "orderId": 380, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4680, "date": "2014/06/08" }, { "orderId": 381, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2475, "date": "2014/06/25" }, { "orderId": 382, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1920, "date": "2014/06/20" }, { "orderId": 383, "region": "Europe", "country": "GBR", "city": "London", "amount": 7500, "date": "2014/06/25" }, { "orderId": 384, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5025, "date": "2014/06/26" }, { "orderId": 385, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2400, "date": "2014/06/08" }, { "orderId": 386, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1720, "date": "2014/06/09" }, { "orderId": 387, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2880, "date": "2014/06/21" }, { "orderId": 388, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5430, "date": "2014/06/03" }, { "orderId": 389, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4475, "date": "2014/06/19" }, { "orderId": 390, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1420, "date": "2014/06/20" }, { "orderId": 391, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2670, "date": "2014/06/25" }, { "orderId": 392, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1930, "date": "2014/06/02" }, { "orderId": 393, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 580, "date": "2014/06/25" }, { "orderId": 394, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1620, "date": "2014/06/12" }, { "orderId": 395, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4530, "date": "2014/06/02" }, { "orderId": 396, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 6025, "date": "2014/06/23" }, { "orderId": 397, "region": "North America", "country": "USA", "city": "New York", "amount": 3540, "date": "2014/07/21" }, { "orderId": 398, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3000, "date": "2014/07/01" }, { "orderId": 399, "region": "North America", "country": "USA", "city": "Denver", "amount": 3240, "date": "2014/07/26" }, { "orderId": 400, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2265, "date": "2014/07/22" }, { "orderId": 401, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 400, "date": "2014/07/09" }, { "orderId": 402, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1460, "date": "2014/07/08" }, { "orderId": 403, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1620, "date": "2014/07/18" }, { "orderId": 404, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2400, "date": "2014/07/25" }, { "orderId": 405, "region": "Europe", "country": "GBR", "city": "London", "amount": 5275, "date": "2014/07/04" }, { "orderId": 406, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4475, "date": "2014/07/03" }, { "orderId": 407, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3980, "date": "2014/07/21" }, { "orderId": 408, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5240, "date": "2014/07/11" }, { "orderId": 409, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1200, "date": "2014/07/21" }, { "orderId": 410, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5700, "date": "2014/07/18" }, { "orderId": 411, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5575, "date": "2014/07/01" }, { "orderId": 412, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2160, "date": "2014/07/02" }, { "orderId": 413, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 960, "date": "2014/07/09" }, { "orderId": 414, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1280, "date": "2014/07/04" }, { "orderId": 415, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1040, "date": "2014/07/02" }, { "orderId": 416, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5520, "date": "2014/07/21" }, { "orderId": 417, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1760, "date": "2014/07/25" }, { "orderId": 418, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4080, "date": "2014/07/07" }, { "orderId": 419, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1000, "date": "2014/07/21" }, { "orderId": 420, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 3270, "date": "2014/07/12" }, { "orderId": 421, "region": "North America", "country": "USA", "city": "New York", "amount": 1770, "date": "2014/08/23" }, { "orderId": 422, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2700, "date": "2014/08/09" }, { "orderId": 423, "region": "North America", "country": "USA", "city": "Denver", "amount": 2175, "date": "2014/08/03" }, { "orderId": 424, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3375, "date": "2014/08/11" }, { "orderId": 425, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2040, "date": "2014/08/01" }, { "orderId": 426, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3000, "date": "2014/08/21" }, { "orderId": 427, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3900, "date": "2014/08/16" }, { "orderId": 428, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1370, "date": "2014/08/20" }, { "orderId": 429, "region": "Europe", "country": "GBR", "city": "London", "amount": 5700, "date": "2014/08/01" }, { "orderId": 430, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1275, "date": "2014/08/22" }, { "orderId": 431, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4060, "date": "2014/08/13" }, { "orderId": 432, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2320, "date": "2014/08/18" }, { "orderId": 433, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7590, "date": "2014/08/24" }, { "orderId": 434, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4560, "date": "2014/08/20" }, { "orderId": 435, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7575, "date": "2014/08/20" }, { "orderId": 436, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 700, "date": "2014/08/25" }, { "orderId": 437, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2400, "date": "2014/08/16" }, { "orderId": 438, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1390, "date": "2014/08/15" }, { "orderId": 439, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1320, "date": "2014/08/09" }, { "orderId": 440, "region": "North America", "country": "USA", "city": "Denver", "amount": 1680, "date": "2014/08/09" }, { "orderId": 441, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1500, "date": "2014/08/11" }, { "orderId": 442, "region": "North America", "country": "USA", "city": "New York", "amount": 6150, "date": "2014/09/21" }, { "orderId": 443, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3675, "date": "2014/09/02" }, { "orderId": 444, "region": "North America", "country": "USA", "city": "Denver", "amount": 2250, "date": "2014/09/05" }, { "orderId": 445, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3585, "date": "2014/09/10" }, { "orderId": 446, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1470, "date": "2014/09/01" }, { "orderId": 447, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2260, "date": "2014/09/02" }, { "orderId": 448, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3765, "date": "2014/09/03" }, { "orderId": 449, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1640, "date": "2014/09/04" }, { "orderId": 450, "region": "Europe", "country": "GBR", "city": "London", "amount": 4475, "date": "2014/09/09" }, { "orderId": 451, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5975, "date": "2014/09/04" }, { "orderId": 452, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1100, "date": "2014/09/16" }, { "orderId": 453, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1320, "date": "2014/09/18" }, { "orderId": 454, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8610, "date": "2014/09/19" }, { "orderId": 455, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9210, "date": "2014/09/09" }, { "orderId": 456, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3700, "date": "2014/09/01" }, { "orderId": 457, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3620, "date": "2014/09/19" }, { "orderId": 458, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4275, "date": "2014/09/01" }, { "orderId": 459, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2370, "date": "2014/09/03" }, { "orderId": 460, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1870, "date": "2014/09/10" }, { "orderId": 461, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2070, "date": "2014/09/25" }, { "orderId": 462, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5025, "date": "2014/09/19" }, { "orderId": 463, "region": "North America", "country": "USA", "city": "New York", "amount": 1080, "date": "2014/10/15" }, { "orderId": 464, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1400, "date": "2014/10/22" }, { "orderId": 465, "region": "North America", "country": "USA", "city": "Denver", "amount": 4260, "date": "2014/10/01" }, { "orderId": 466, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2745, "date": "2014/10/01" }, { "orderId": 467, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2920, "date": "2014/10/23" }, { "orderId": 468, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3520, "date": "2014/10/11" }, { "orderId": 469, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4035, "date": "2014/10/20" }, { "orderId": 470, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1730, "date": "2014/10/05" }, { "orderId": 471, "region": "Europe", "country": "GBR", "city": "London", "amount": 975, "date": "2014/10/06" }, { "orderId": 472, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5700, "date": "2014/10/06" }, { "orderId": 473, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5080, "date": "2014/10/18" }, { "orderId": 474, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2940, "date": "2014/10/24" }, { "orderId": 475, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2670, "date": "2014/10/04" }, { "orderId": 476, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1230, "date": "2014/10/11" }, { "orderId": 477, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 600, "date": "2014/10/08" }, { "orderId": 478, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3700, "date": "2014/10/08" }, { "orderId": 479, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3375, "date": "2014/10/11" }, { "orderId": 480, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1500, "date": "2014/10/17" }, { "orderId": 481, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 370, "date": "2014/10/05" }, { "orderId": 482, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2340, "date": "2014/10/16" }, { "orderId": 483, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1080, "date": "2014/10/08" }, { "orderId": 484, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2775, "date": "2014/10/21" }, { "orderId": 485, "region": "North America", "country": "USA", "city": "New York", "amount": 4380, "date": "2014/11/09" }, { "orderId": 486, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5500, "date": "2014/11/21" }, { "orderId": 487, "region": "North America", "country": "USA", "city": "Denver", "amount": 1920, "date": "2014/11/24" }, { "orderId": 488, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 765, "date": "2014/11/24" }, { "orderId": 489, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 370, "date": "2014/11/18" }, { "orderId": 490, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3500, "date": "2014/11/25" }, { "orderId": 491, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 825, "date": "2014/11/09" }, { "orderId": 492, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 490, "date": "2014/11/23" }, { "orderId": 493, "region": "Europe", "country": "GBR", "city": "London", "amount": 7075, "date": "2014/11/20" }, { "orderId": 494, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1350, "date": "2014/11/25" }, { "orderId": 495, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1440, "date": "2014/11/15" }, { "orderId": 496, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2820, "date": "2014/11/13" }, { "orderId": 497, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2280, "date": "2014/11/12" }, { "orderId": 498, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1110, "date": "2014/11/03" }, { "orderId": 499, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 1150, "date": "2014/11/23" }, { "orderId": 500, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2040, "date": "2014/11/20" }, { "orderId": 501, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3090, "date": "2014/11/24" }, { "orderId": 502, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1940, "date": "2014/11/24" }, { "orderId": 503, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 3090, "date": "2014/11/16" }, { "orderId": 504, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4900, "date": "2014/11/05" }, { "orderId": 505, "region": "North America", "country": "USA", "city": "Denver", "amount": 3465, "date": "2014/11/07" }, { "orderId": 506, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1110, "date": "2014/11/20" }, { "orderId": 507, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1650, "date": "2014/11/02" }, { "orderId": 508, "region": "North America", "country": "USA", "city": "New York", "amount": 5280, "date": "2014/12/04" }, { "orderId": 509, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3075, "date": "2014/12/02" }, { "orderId": 510, "region": "North America", "country": "USA", "city": "Denver", "amount": 690, "date": "2014/12/07" }, { "orderId": 511, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1305, "date": "2014/12/15" }, { "orderId": 512, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1970, "date": "2014/12/01" }, { "orderId": 513, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3760, "date": "2014/12/18" }, { "orderId": 514, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1920, "date": "2014/12/22" }, { "orderId": 515, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1360, "date": "2014/12/12" }, { "orderId": 516, "region": "Europe", "country": "GBR", "city": "London", "amount": 2525, "date": "2014/12/06" }, { "orderId": 517, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5575, "date": "2014/12/20" }, { "orderId": 518, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5560, "date": "2014/12/10" }, { "orderId": 519, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4880, "date": "2014/12/13" }, { "orderId": 520, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8850, "date": "2014/12/03" }, { "orderId": 521, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2820, "date": "2014/12/10" }, { "orderId": 522, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4000, "date": "2014/12/12" }, { "orderId": 523, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5820, "date": "2014/12/02" }, { "orderId": 524, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1275, "date": "2014/12/12" }, { "orderId": 525, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1310, "date": "2014/12/01" }, { "orderId": 526, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2180, "date": "2014/12/26" }, { "orderId": 527, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4470, "date": "2014/12/17" }, { "orderId": 528, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2990, "date": "2014/12/15" }, { "orderId": 529, "region": "Europe", "country": "GBR", "city": "London", "amount": 7650, "date": "2014/12/18" }, { "orderId": 530, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 780, "date": "2014/12/02" }, { "orderId": 531, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2970, "date": "2014/12/13" }, { "orderId": 532, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1155, "date": "2014/12/05" }, { "orderId": 533, "region": "North America", "country": "USA", "city": "New York", "amount": 4470, "date": "2015/01/10" }, { "orderId": 534, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1125, "date": "2015/01/21" }, { "orderId": 535, "region": "North America", "country": "USA", "city": "Denver", "amount": 645, "date": "2015/01/17" }, { "orderId": 536, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 675, "date": "2015/01/05" }, { "orderId": 537, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2840, "date": "2015/01/05" }, { "orderId": 538, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2660, "date": "2015/01/04" }, { "orderId": 539, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4560, "date": "2015/01/12" }, { "orderId": 540, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2880, "date": "2015/01/20" }, { "orderId": 541, "region": "Europe", "country": "GBR", "city": "London", "amount": 500, "date": "2015/01/02" }, { "orderId": 542, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3925, "date": "2015/01/07" }, { "orderId": 543, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5660, "date": "2015/01/18" }, { "orderId": 544, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1460, "date": "2015/01/22" }, { "orderId": 545, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5040, "date": "2015/01/10" }, { "orderId": 546, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4830, "date": "2015/01/13" }, { "orderId": 547, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3075, "date": "2015/01/22" }, { "orderId": 548, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3120, "date": "2015/01/14" }, { "orderId": 549, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3525, "date": "2015/01/23" }, { "orderId": 550, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1930, "date": "2015/01/09" }, { "orderId": 551, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2890, "date": "2015/01/02" }, { "orderId": 552, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1545, "date": "2015/01/17" }, { "orderId": 553, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3630, "date": "2015/01/20" }, { "orderId": 554, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4035, "date": "2015/01/14" }, { "orderId": 555, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 345, "date": "2015/01/06" }, { "orderId": 556, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7000, "date": "2015/01/07" }, { "orderId": 557, "region": "North America", "country": "USA", "city": "New York", "amount": 3060, "date": "2015/02/13" }, { "orderId": 558, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 6425, "date": "2015/02/04" }, { "orderId": 559, "region": "North America", "country": "USA", "city": "Denver", "amount": 615, "date": "2015/02/22" }, { "orderId": 560, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1755, "date": "2015/02/07" }, { "orderId": 561, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1540, "date": "2015/02/21" }, { "orderId": 562, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2820, "date": "2015/02/24" }, { "orderId": 563, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4305, "date": "2015/02/10" }, { "orderId": 564, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1520, "date": "2015/02/26" }, { "orderId": 565, "region": "Europe", "country": "GBR", "city": "London", "amount": 4725, "date": "2015/02/18" }, { "orderId": 566, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 6750, "date": "2015/02/16" }, { "orderId": 567, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5540, "date": "2015/02/07" }, { "orderId": 568, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1880, "date": "2015/02/24" }, { "orderId": 569, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6180, "date": "2015/02/26" }, { "orderId": 570, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9300, "date": "2015/02/03" }, { "orderId": 571, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3700, "date": "2015/02/26" }, { "orderId": 572, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 740, "date": "2015/02/01" }, { "orderId": 573, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4755, "date": "2015/02/23" }, { "orderId": 574, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2570, "date": "2015/02/20" }, { "orderId": 575, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2860, "date": "2015/02/19" }, { "orderId": 576, "region": "North America", "country": "USA", "city": "New York", "amount": 5430, "date": "2015/03/21" }, { "orderId": 577, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2015/03/21" }, { "orderId": 578, "region": "North America", "country": "USA", "city": "Denver", "amount": 1515, "date": "2015/03/10" }, { "orderId": 579, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 630, "date": "2015/03/15" }, { "orderId": 580, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1310, "date": "2015/03/01" }, { "orderId": 581, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3200, "date": "2015/03/17" }, { "orderId": 582, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3945, "date": "2015/03/20" }, { "orderId": 583, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2990, "date": "2015/03/18" }, { "orderId": 584, "region": "Europe", "country": "GBR", "city": "London", "amount": 1125, "date": "2015/03/22" }, { "orderId": 585, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7950, "date": "2015/03/17" }, { "orderId": 586, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2960, "date": "2015/03/25" }, { "orderId": 587, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 6300, "date": "2015/03/20" }, { "orderId": 588, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8670, "date": "2015/03/07" }, { "orderId": 589, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3930, "date": "2015/03/23" }, { "orderId": 590, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6975, "date": "2015/03/02" }, { "orderId": 591, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4220, "date": "2015/03/17" }, { "orderId": 592, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3090, "date": "2015/03/25" }, { "orderId": 593, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2380, "date": "2015/03/01" }, { "orderId": 594, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1510, "date": "2015/03/07" }, { "orderId": 595, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1020, "date": "2015/03/19" }, { "orderId": 596, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6700, "date": "2015/03/26" }, { "orderId": 597, "region": "North America", "country": "USA", "city": "New York", "amount": 4890, "date": "2015/04/02" }, { "orderId": 598, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7225, "date": "2015/04/13" }, { "orderId": 599, "region": "North America", "country": "USA", "city": "Denver", "amount": 795, "date": "2015/04/07" }, { "orderId": 600, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1785, "date": "2015/04/03" }, { "orderId": 601, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1850, "date": "2015/04/03" }, { "orderId": 602, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5120, "date": "2015/04/12" }, { "orderId": 603, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 615, "date": "2015/04/07" }, { "orderId": 604, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2860, "date": "2015/04/05" }, { "orderId": 605, "region": "Europe", "country": "GBR", "city": "London", "amount": 1525, "date": "2015/04/24" }, { "orderId": 606, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7425, "date": "2015/04/15" }, { "orderId": 607, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 6080, "date": "2015/04/13" }, { "orderId": 608, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2940, "date": "2015/04/04" }, { "orderId": 609, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5580, "date": "2015/04/16" }, { "orderId": 610, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9390, "date": "2015/04/19" }, { "orderId": 611, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3200, "date": "2015/04/26" }, { "orderId": 612, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4380, "date": "2015/04/05" }, { "orderId": 613, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4725, "date": "2015/04/06" }, { "orderId": 614, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 930, "date": "2015/04/25" }, { "orderId": 615, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1910, "date": "2015/04/05" }, { "orderId": 616, "region": "Europe", "country": "GBR", "city": "London", "amount": 2725, "date": "2015/04/16" }, { "orderId": 617, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4720, "date": "2015/04/02" }, { "orderId": 618, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5190, "date": "2015/04/10" }, { "orderId": 619, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2800, "date": "2015/04/26" }, { "orderId": 620, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3780, "date": "2015/04/24" }, { "orderId": 621, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2340, "date": "2015/04/17" }, { "orderId": 622, "region": "North America", "country": "USA", "city": "New York", "amount": 4830, "date": "2015/05/12" }, { "orderId": 623, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2075, "date": "2015/05/23" }, { "orderId": 624, "region": "North America", "country": "USA", "city": "Denver", "amount": 3420, "date": "2015/05/21" }, { "orderId": 625, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1440, "date": "2015/05/10" }, { "orderId": 626, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1680, "date": "2015/05/15" }, { "orderId": 627, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3440, "date": "2015/05/16" }, { "orderId": 628, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4695, "date": "2015/05/10" }, { "orderId": 629, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2380, "date": "2015/05/06" }, { "orderId": 630, "region": "Europe", "country": "GBR", "city": "London", "amount": 1875, "date": "2015/05/25" }, { "orderId": 631, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7550, "date": "2015/05/14" }, { "orderId": 632, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3340, "date": "2015/05/01" }, { "orderId": 633, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1400, "date": "2015/05/22" }, { "orderId": 634, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6060, "date": "2015/05/22" }, { "orderId": 635, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 8370, "date": "2015/05/13" }, { "orderId": 636, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3550, "date": "2015/05/26" }, { "orderId": 637, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2620, "date": "2015/05/17" }, { "orderId": 638, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2400, "date": "2015/05/21" }, { "orderId": 639, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1740, "date": "2015/05/21" }, { "orderId": 640, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 500, "date": "2015/05/26" }, { "orderId": 641, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 780, "date": "2015/05/07" }]; var layouts = [{ key: 0, name: "Layout0" }, { key: 1, name: "Layout1" }, { key: 2, name: "Layout2" }];