Working with data
2 Mar 202224 minutes to read
Heat map visualizes the JSON data and two-dimensional array data. Using the data adaptor support, data can be bound to the heat map.
Data adaptor
Heat map supports the following types of data binding with the adaptor support.
- Array
- Table Binding
- Cell Binding
- JSON data
- Table Binding
- Cell Binding
Array - table binding
This data type is a collection of one dimensional array objects, at which each inner array contains data points for an X-axis data label. This is the default data binding type for heat map. You can also directly bind the array object to the dataSource property.
<ejs-heatmap id='container' dataSource="ViewBag.dataSource">
<e-heatmap-titlesettings text="GDP Growth Rate for Major Economies (in Percentage)" textStyle="ViewBag.textStyle">
</e-heatmap-titlesettings>
<e-heatmap-xaxis labels="ViewBag.xLabels" labelRotation="45" labelIntersectAction="None"></e-heatmap-xaxis>
<e-heatmap-yaxis labels="ViewBag.yLabels"></e-heatmap-yaxis>
<e-heatmap-palettesettings>
<e-palettes>
<e-palette value=-1 color="#F0D6AD"></e-palette>
<e-palette value=0 color="#9da49a"></e-palette>
<e-palette value=3.5 color="#d7c7a7"></e-palette>
<e-palette value=6.0 color="#6e888f"></e-palette>
<e-palette value=7.5 color="#466f86"></e-palette>
<e-palette value=10 color="#19547B"></e-palette>
</e-palettes>
</e-heatmap-palettesettings>
<e-heatmap-legendsettings visible="false"></e-heatmap-legendsettings>
</ejs-heatmap>public ActionResult ArrayRow()
{
ViewBag.textStyle = new
{
size= "15px",
fontWeight= "500",
fontStyle= "Normal",
fontFamily= "Segoe UI"
};
string[] xlabels = new string[12] { "China", "India", "Australia", "Mexico", "Canada", "Brazil",
"USA", "UK", "Germany", "Russia", "France", "Japan"};
ViewBag.xLabels = xlabels;
string[] yLabels = new string[10] { "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017" };
ViewBag.yLabels = yLabels;
ViewBag.dataSource = GetDataSource();
return View();
}
private double[,] GetDataSource()
{
double[,] data = new double[12, 10]
{
{9.5, 2.2, 4.2, 8.2, -0.5, 3.2, 5.4, 7.4, 6.2, 1.4 },
{4.3, 8.9, 10.8, 6.5, 5.1, 6.2, 7.6, 7.5, 6.1, 7.6},
{3.9, 2.7, 2.5, 3.7, 2.6, 5.1, 5.8, 2.9, 4.5, 5.1},
{2.4, -3.7, 4.1, 6.0, 5.0, 2.4, 3.3, 4.6, 4.3, 2.7},
{2.0, 7.0, -4.1, 8.9, 2.7, 5.9, 5.6, 1.9, -1.7, 2.9},
{5.4, 1.1, 6.9, 4.5, 2.9, 3.4, 1.5, -2.8, -4.6, 1.2},
{-1.3, 3.9, 3.5, 6.6, 5.2, 7.7, 1.4, -3.6, 6.6, 4.3},
{-1.6, 2.3, 2.9, -2.5, 1.3, 4.9, 10.1, 3.2, 4.8, 2.0},
{10.8, -1.6, 4.0, 6.0, 7.7, 2.6, 5.6, -2.5, 3.8, -1.9},
{6.2, 9.8, -1.5, 2.0, -1.5, 4.3, 6.7, 3.8, -1.2, 2.4},
{1.2, 10.9, 4.0, -1.4, 2.2, 1.6, -2.6, 2.3, 1.7, 2.4},
{5.1, -2.4, 8.2, -1.1, 3.5, 6.0, -1.3, 7.2, 9.0, 4.2}
};
return data;
}Array - cell binding
This data type is a collection of array objects that contain information about the row index, column index, and data value for each cell. You can bind the data to heat map by using the data property in the dataSource and setting the adaptorType property to Cell.
<ejs-heatmap id='container' dataSource="ViewBag.dataSource" tooltipRender="window.ontooltipRender">
<e-heatmap-titlesettings text="Percentage of Individuals Using Internet by Country" textStyle="ViewBag.textStyle">
</e-heatmap-titlesettings>
<e-heatmap-xaxis labels="ViewBag.xLabels"></e-heatmap-xaxis>
<e-heatmap-yaxis labels="ViewBag.yLabels"></e-heatmap-yaxis>
<e-heatmap-palettesettings>
<e-palettes>
<e-palette color="#3498DB"></e-palette>
<e-palette color="#2C3E50"></e-palette>
</e-palettes>
</e-heatmap-palettesettings>
<e-heatmap-cellsettings border="ViewBag.border" textStyle="ViewBag.cellTextStyle" format="{value} %">
</e-heatmap-cellsettings>
<e-heatmap-legendsettings visible="false"></e-heatmap-legendsettings>
<e-heatmap-datasourcesettings isJsonData="false" adaptorType="Cell"></e-heatmap-datasourcesettings>
</ejs-heatmap>
<script>
window.ontooltipRender = function (args) {
args.content = [args.yLabel + ' | ' + args.xLabel + ' : ' + args.value + ' %'];
}
</script>public ActionResult ArrayCell()
{
ViewBag.textStyle = new
{
size= "15px",
fontWeight= "500",
fontStyle= "Normal",
fontFamily= "Segoe UI"
};
string[] xlabels = new string[12] { "China", "India", "Australia", "Mexico", "Canada", "Brazil",
"USA", "UK", "Germany", "Russia", "France", "Japan"};
ViewBag.xLabels = xlabels;
string[] yLabels = new string[7] { "2000", "2005", "2010", "2011", "2012", "2013", "2014" };
ViewBag.yLabels = yLabels;
ViewBag.border = new { width = 0 };
ViewBag.cellTextStyle = new { color = "white" };
double[,] cellData = new double[,]
{
{0, 0, 10.75}, {0, 1, 14.5}, {0, 2, 25.5}, {0, 3, 39.5}, {0, 4, 59.75}, {0, 5, 35.50}, {0, 6, 75.5},
{1, 0, 20.75}, {1, 1, 35.5}, {1, 2, 29.5}, {1, 3, 75.5}, {1, 4, 80}, {1, 5, 65}, {1, 6, 85},
{2, 0, 6}, {2, 1, 18.5}, {2, 2, 30.05}, {2, 3, 35.5}, {2, 4, 40.75}, {2, 5, 50.75}, {2, 6, 65},
{3, 0, 30.5}, {3, 1, 20.5}, {3, 2, 45.30}, {3, 3, 50}, {3, 4, 55}, {3, 5, 85.80}, {3, 6, 87.5},
{4, 0, 10.5}, {4, 1, 20.75}, {4, 2, 35.5}, {4, 3, 35.5}, {4, 4, 45.5}, {4, 5, 65}, {4, 6, 75.5},
{5, 0, 45.5}, {5, 1, 20.75}, {5, 2, 45.5}, {5, 3, 50.75}, {5, 4, 79.30}, {5, 5, 84.20}, {5, 6, 87.36},
{6, 0, 26.82}, {6, 1, 70}, {6, 2, 75}, {6, 3, 79.5}, {6, 4, 88.5}, {6, 5, 89.5}, {6, 6, 91.75},
{7, 0, 15.75}, {7, 1, 20.75}, {7, 2, 25.5}, {7, 3, 42.35}, {7, 4, 45.15}, {7, 5, 76.5}, {7, 6, 80.5},
{8, 0, 1.98}, {8, 1, 15.23}, {8, 2, 43}, {8, 3, 49}, {8, 4, 63.80}, {8, 5, 67.97}, {8, 6, 70.52},
{9, 0, 14.31}, {9, 1, 42.87}, {9, 2, 77.28}, {9, 3, 77.82}, {9, 4, 81.44}, {9, 5, 81.92}, {9, 6, 83.75},
{10, 0, 25.5}, {10, 1, 35.5}, {10, 2, 40.5}, {10, 3, 45.05}, {10, 4, 50.5}, {10, 5, 75.5}, {10, 6, 90.58}
};
ViewBag.dataSource = cellData;
return View();
}JSON data - table binding
In JSON table data binding, each JSON object contains an X-axis data point as row header and all the corresponding Y-axis data values. You can bind the JSON table data to the heat map using the data property in dataSource. To achieve this, you should enable the isJsonData property and define the adaptorType property as Table. The xDataMapping property is used to map the row header in JSON data.
<ejs-heatmap id='container' load="window.onHeatmapLoad" tooltipRender="window.ontooltipRender">
<e-heatmap-titlesettings text="Olympic Medal Achievements of most Successful Countries" textStyle="ViewBag.textStyle">
</e-heatmap-titlesettings>
<e-heatmap-xaxis labels="ViewBag.xLabels" labelRotation="45" labelIntersectAction="None"></e-heatmap-xaxis>
<e-heatmap-yaxis labels="ViewBag.yLabels" title="ViewBag.title"></e-heatmap-yaxis>
<e-heatmap-palettesettings>
<e-palettes>
<e-palette color="#F0C27B"></e-palette>
<e-palette color="#4B1248"></e-palette>
</e-palettes>
</e-heatmap-palettesettings>
<e-heatmap-cellsettings border="ViewBag.border"></e-heatmap-cellsettings>
<e-heatmap-datasourcesettings isJsonData="true" adaptorType="Table" xDataMapping="Region"></e-heatmap-datasourcesettings>
<e-heatmap-legendsettings visible="false"></e-heatmap-legendsettings>
</ejs-heatmap>
<script>
var dataSource = [
{ "Region": "USA", "2000": 93, "2004": 101, "2008": 112, "2012": 103, "2016": 121 },
{ "Region": "GBR", "2000": 28, "2004": 30, "2008": 49, "2012": 65, "2016": 67 },
{ "Region": "China", "2000": 58, "2004": 63, "2008": 100, "2012": 91, "2016": 70 },
{ "Region": "Russia", "2000": 89, "2004": 90, "2008": 60, "2012": 69, "2016": 55 },
{ "Region": "Germany", "2000": 56, "2004": 49, "2008": 41, "2012": 44, "2016": 42 },
{ "Region": "Japan", "2000": 18, "2004": 37, "2008": 25, "2012": 38, "2016": 41 },
{ "Region": "France", "2000": 38, "2004": 33, "2008": 43, "2012": 35, "2016": 42 },
{ "Region": "KOR", "2000": 28, "2004": 30, "2008": 32, "2012": 30, "2016": 21 },
{ "Region": "Italy", "2000": 34, "2004": 32, "2008": 27, "2012": 28, "2016": 28 },
];
window.onHeatmapLoad = function (args) {
args.heatmap.dataSource = dataSource;
}
window.ontooltipRender = function (args) {
args.content = [args.yLabel + " | " + args.xLabel + " : " + args.value + " medals"];
}
</script>public ActionResult JsonRow()
{
ViewBag.textStyle = new
{
size = "15px",
fontWeight = "500",
fontStyle = "Normal",
fontFamily = "Segoe UI"
};
ViewBag.border = new
{
width = 0,
radius = 4,
color = "white"
};
string[] xlabels = new string[9] { "China", "France", "GBR", "Germany", "Italy", "Japan", "KOR", "Russia", "USA" };
ViewBag.xLabels = xlabels;
string[] yLabels = new string[5] { "2000", "2004", "2008", "2012", "2016" };
ViewBag.yLabels = yLabels;
ViewBag.title = new { text = "Olympic Year" };
return View();
}JSON data - Cell binding
In JSON cell data binding, each JSON object consists a value for each cell along with a mapping value for row and column. You can bind the JSON cell data having information for each cell to the heat map using the data property in dataSource. To achieve this, you should define the adaptorType property as Cell. and enable the isJsonData property. Now, map the fields of data by using the valueMapping, xDataMapping and yDataMapping properties.
<ejs-heatmap id='container' load="window.onHeatmapLoad">
<e-heatmap-titlesettings text="Most Visited Destinations by International Tourist Arrivals" textStyle="ViewBag.textStyle">
</e-heatmap-titlesettings>
<e-heatmap-xaxis labels="ViewBag.xLabels"></e-heatmap-xaxis>
<e-heatmap-yaxis labels="ViewBag.yLabels"></e-heatmap-yaxis>
<e-heatmap-palettesettings>
<e-palettes>
<e-palette color="#DCD57E"></e-palette>
<e-palette color="#A6DC7E"></e-palette>
<e-palette color="#7EDCA2"></e-palette>
<e-palette color="#6EB5D0"></e-palette>
</e-palettes>
</e-heatmap-palettesettings>
<e-heatmap-cellsettings border="ViewBag.border" showLabel="true" format="{value} M">
<e-heatmap-datasourcesettings isJsonData="true" adaptorType="Cell" xDataMapping="rowid" yDataMapping="columnid" valueMapping="value"></e-heatmap-datasourcesettings>
</e-heatmap-cellsettings>
</ejs-heatmap>
<script>
// Initializing json Data
var dataSource = [
{ "rowid": "France", "columnid": "2010", "value": "77.6" },
{ "rowid": "France", "columnid": "2011", "value": "79.4" },
{ "rowid": "France", "columnid": "2012", "value": "80.8" },
{ "rowid": "France", "columnid": "2013", "value": "86.6" },
{ "rowid": "France", "columnid": "2014", "value": "83.7" },
{ "rowid": "France", "columnid": "2015", "value": "84.5" },
{ "rowid": "France", "columnid": "2016", "value": "82.6" },
{ "rowid": "USA", "columnid": "2010", "value": "60.6" },
{ "rowid": "USA", "columnid": "2011", "value": "65.4" },
{ "rowid": "USA", "columnid": "2012", "value": "70.8" },
{ "rowid": "USA", "columnid": "2013", "value": "73.8" },
{ "rowid": "USA", "columnid": "2014", "value": "75.3" },
{ "rowid": "USA", "columnid": "2015", "value": "77.5" },
{ "rowid": "USA", "columnid": "2016", "value": "77.6" },
{ "rowid": "Spain", "columnid": "2010", "value": "64.9" },
{ "rowid": "Spain", "columnid": "2011", "value": "52.6" },
{ "rowid": "Spain", "columnid": "2012", "value": "60.8" },
{ "rowid": "Spain", "columnid": "2013", "value": "65.6" },
{ "rowid": "Spain", "columnid": "2014", "value": "52.6" },
{ "rowid": "Spain", "columnid": "2015", "value": "68.5" },
{ "rowid": "Spain", "columnid": "2016", "value": "75.6" },
{ "rowid": "China", "columnid": "2010", "value": "55.6" },
{ "rowid": "China", "columnid": "2011", "value": "52.3" },
{ "rowid": "China", "columnid": "2012", "value": "54.8" },
{ "rowid": "China", "columnid": "2013", "value": "51.1" },
{ "rowid": "China", "columnid": "2014", "value": "55.6" },
{ "rowid": "China", "columnid": "2015", "value": "56.9" },
{ "rowid": "China", "columnid": "2016", "value": "59.3" },
{ "rowid": "Italy", "columnid": "2010", "value": "43.6" },
{ "rowid": "Italy", "columnid": "2011", "value": "43.2" },
{ "rowid": "Italy", "columnid": "2012", "value": "55.8" },
{ "rowid": "Italy", "columnid": "2013", "value": "50.1" },
{ "rowid": "Italy", "columnid": "2014", "value": "48.5" },
{ "rowid": "Italy", "columnid": "2015", "value": "50.7" },
{ "rowid": "Italy", "columnid": "2016", "value": "52.4" },
{ "rowid": "UK", "columnid": "2010", "value": "28.2" },
{ "rowid": "UK", "columnid": "2011", "value": "31.6" },
{ "rowid": "UK", "columnid": "2012", "value": "29.8" },
{ "rowid": "UK", "columnid": "2013", "value": "33.1" },
{ "rowid": "UK", "columnid": "2014", "value": "32.6" },
{ "rowid": "UK", "columnid": "2015", "value": "34.4" },
{ "rowid": "UK", "columnid": "2016", "value": "35.8" },
{ "rowid": "Germany", "columnid": "2010", "value": "26.8" },
{ "rowid": "Germany", "columnid": "2011", "value": "29" },
{ "rowid": "Germany", "columnid": "2012", "value": "26.8" },
{ "rowid": "Germany", "columnid": "2013", "value": "27.6" },
{ "rowid": "Germany", "columnid": "2014", "value": "33" },
{ "rowid": "Germany", "columnid": "2015", "value": "35" },
{ "rowid": "Germany", "columnid": "2016", "value": "35.6" },
{ "rowid": "Mexico", "columnid": "2010", "value": "23.2" },
{ "rowid": "Mexico", "columnid": "2011", "value": "24.9" },
{ "rowid": "Mexico", "columnid": "2012", "value": "30.1" },
{ "rowid": "Mexico", "columnid": "2013", "value": "22.2" },
{ "rowid": "Mexico", "columnid": "2014", "value": "29.3" },
{ "rowid": "Mexico", "columnid": "2015", "value": "32.1" },
{ "rowid": "Mexico", "columnid": "2016", "value": "35" },
{ "rowid": "Thailand", "columnid": "2010", "value": "15.9" },
{ "rowid": "Thailand", "columnid": "2011", "value": "19.8" },
{ "rowid": "Thailand", "columnid": "2012", "value": "21.8" },
{ "rowid": "Thailand", "columnid": "2013", "value": "23.5" },
{ "rowid": "Thailand", "columnid": "2014", "value": "24.8" },
{ "rowid": "Thailand", "columnid": "2015", "value": "29.9" },
{ "rowid": "Thailand", "columnid": "2016", "value": "32.6" },
{ "rowid": "Austria", "columnid": "2010", "value": "22" },
{ "rowid": "Austria", "columnid": "2011", "value": "21.3" },
{ "rowid": "Austria", "columnid": "2012", "value": "24.2" },
{ "rowid": "Austria", "columnid": "2013", "value": "23.2" },
{ "rowid": "Austria", "columnid": "2014", "value": "25" },
{ "rowid": "Austria", "columnid": "2015", "value": "26.7" },
{ "rowid": "Austria", "columnid": "2016", "value": "28.1" },
];
window.onHeatmapLoad = function (args) {
args.heatmap.dataSource = dataSource;
}
</script>public ActionResult JsonCell()
{
ViewBag.textStyle = new
{
size= "15px",
fontWeight= "500",
fontStyle= "Normal",
fontFamily= "Segoe UI"
};
ViewBag.border = new
{
width = 1,
radius = 4,
color = "white"
};
string[] xlabels = new string[10] { "Austria", "China", "France", "Germany", "Italy", "Mexico", "Spain", "Thailand", "UK", "USA" };
ViewBag.xLabels = xlabels;
string[] yLabels = new string[7] { "2010", "2011", "2012", "2013", "2014", "2015", "2016" };
ViewBag.yLabels = yLabels;
return View();
}Empty points
The data points that use the null or "" or undefined as value are considered as empty points. Empty data points are ignored and not displayed in the heat map, and these points are rendered with default palette. You can customize the empty data point color value using the emptyPointColor property.
@{
var Xminimum = new DateTime(2007, 1, 1);
}
<ejs-heatmap id='container' dataSource="ViewBag.dataSource">
<e-heatmap-xaxis minimum="Xminimum" intervalType="Years" valueType="DateTime" labelFormat="yyyy">
</e-heatmap-xaxis>
<e-heatmap-yaxis valueType="Numeric">
</e-heatmap-yaxis>
<e-heatmap-legendsettings visible="false"></e-heatmap-legendsettings>
</ejs-heatmap>public ActionResult EmptyPoints()
{
ViewBag.dataSource = GetDataSource();
return View();
}
private int[,] GetDataSource()
{
int[,] data = new int[,]
{
[73, 39, 26, 39, 94, 0],
[93, 58, 53, 38, 26, 68],
[99, 28, null, 4, 66, 90],
[14, 26, 97, 69, 69, 3],
[7, 46, 47, 47, 88, 6],
[41, 55, 73, 23, "", 79],
[56, 69, 21, 86, 3, 33],
[45, 7, undefined, 81, 95, 79],
[60, 77, 74, 68, 88, 51],
[25, 25, 10, 12, 78, 14],
[25, 56, 55, 58, 12, 82],
[74, 33, 88, 23, 86, 59]
};
return data;
}Binding nested JSON data
In complex data binding, you can bind the nested JSON data to the data points in the heat map. The nested data can be mapped using the xDataMapping, yDataMapping, valueMapping and bubbleDataMapping properties as string value concatenated by a dot.
<ejs-heatmap id='container' load="window.onHeatmapLoad">
<e-heatmap-titlesettings text="Most Visited Destinations by International Tourist Arrivals" textStyle="ViewBag.textStyle">
</e-heatmap-titlesettings>
<e-heatmap-xaxis labels="ViewBag.xLabels"></e-heatmap-xaxis>
<e-heatmap-yaxis labels="ViewBag.yLabels"></e-heatmap-yaxis>
<e-heatmap-palettesettings>
<e-palettes>
<e-palette color="#DCD57E"></e-palette>
<e-palette color="#A6DC7E"></e-palette>
<e-palette color="#7EDCA2"></e-palette>
<e-palette color="#6EB5D0"></e-palette>
</e-palettes>
</e-heatmap-palettesettings>
<e-heatmap-cellsettings border="ViewBag.border" showLabel="true" format="{value} M">
<e-heatmap-datasourcesettings isJsonData="true" adaptorType="Cell" xDataMapping="Labels.YLabel" yDataMapping="Labels.Ylabel" valueMapping="data.value"></e-heatmap-datasourcesettings>
</e-heatmap-cellsettings>
</ejs-heatmap>
<script>
var dataSource = [
{ 'Labels':{'Xlabel': 'France','Ylabel': '2010' },'data':{'value': '77.6' }},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2011'},'data':{'value': '79.4'}},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2012'},'data':{'value': '80.8'}},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2013'},'data':{'value': '86.6'}},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2014'},'data':{'value': '83.7'}},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2015'},'data':{'value': '84.5'}},
{ 'Labels':{'Xlabel': 'France','Ylabel': '2016'},'data':{'value': '82.6'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2010'},'data':{'value': '60.6'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2011'},'data':{'value': '65.4'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2012'},'data':{'value': '70.8'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2013'},'data':{'value': '73.8'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2014'},'data':{'value': '75.3'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2015'},'data':{'value': '77.5'}},
{ 'Labels':{'Xlabel': 'USA','Ylabel': '2016'},'data':{'value': '77.6'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2010'},'data':{'value': '64.9'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2011'},'data':{'value': '52.6'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2012'},'data':{'value': '60.8'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2013'},'data':{'value': '65.6'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2014'},'data':{'value': '52.6'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2015'},'data':{'value': '68.5'}},
{ 'Labels':{'Xlabel': 'Spain','Ylabel': '2016'},'data':{'value': '75.6'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2010'},'data':{'value': '55.6'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2011'},'data':{'value': '52.3'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2012'},'data':{'value': '54.8'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2013'},'data':{'value': '51.1'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2014'},'data':{'value': '55.6'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2015'},'data':{'value': '56.9'}},
{ 'Labels':{'Xlabel': 'China','Ylabel': '2016'},'data':{'value': '59.3'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2010'},'data':{'value': '43.6'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2011'},'data':{'value': '43.2'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2012'},'data':{'value': '55.8'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2013'},'data':{'value': '50.1'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2014'},'data':{'value': '48.5'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2015'},'data':{'value': '50.7'}},
{ 'Labels':{'Xlabel': 'Italy','Ylabel': '2016'},'data':{'value': '52.4'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2010'},'data':{'value': '28.2'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2011'},'data':{'value': '31.6'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2012'},'data':{'value': '29.8'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2013'},'data':{'value': '33.1'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2014'},'data':{'value': '32.6'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2015'},'data':{'value': '34.4'}},
{ 'Labels':{'Xlabel': 'UK','Ylabel': '2016'},'data':{'value': '35.8'}},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2010'},'data':{'value': '26.8'}},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2011'},'data':{'value': '29' }},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2012'},'data':{'value': '26.8'}},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2013'},'data':{'value': '27.6'}},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2014'},'data':{'value': '33' }},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2015'},'data':{'value': '35' }},
{ 'Labels':{'Xlabel': 'Germany','Ylabel': '2016'},'data':{'value': '35.6'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2010'},'data':{'value': '23.2'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2011'},'data':{'value': '24.9'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2012'},'data':{'value': '30.1'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2013'},'data':{'value': '22.2'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2014'},'data':{'value': '29.3'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2015'},'data':{'value': '32.1'}},
{ 'Labels':{'Xlabel': 'Mexico','Ylabel': '2016'}, 'data':{'value': '35' }},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2010'},'data':{'value': '15.9'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2011'},'data':{'value': '19.8'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2012'},'data':{'value': '21.8'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2013'},'data':{'value': '23.5'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2014'},'data':{'value': '24.8'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2015'},'data':{'value': '29.9'}},
{ 'Labels':{'Xlabel': 'Thailand','Ylabel': '2016'},'data':{'value': '32.6'}},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2010'},'data':{'value': '22' }},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2011'},'data':{'value': '21.3'}},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2012'},'data':{'value': '24.2'}},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2013'},'data':{'value': '23.2'}},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2014'},'data':{'value': '25' }},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2015'},'data':{'value': '26.7' }},
{ 'Labels':{'Xlabel': 'Austria','Ylabel': '2016'},'data':{'value': '28.1' }}
];
window.onHeatmapLoad = function (args) {
args.heatmap.dataSource = dataSource;
}
</script>public ActionResult JsonCell()
{
ViewBag.textStyle = new
{
size= "15px",
fontWeight= "500",
fontStyle= "Normal",
fontFamily= "Segoe UI"
};
ViewBag.border = new
{
width = 1,
radius = 4,
color = "white"
};
string[] xlabels = new string[10] { "Austria", "China", "France", "Germany", "Italy", "Mexico", "Spain", "Thailand", "UK", "USA" };
ViewBag.xLabels = xlabels;
string[] yLabels = new string[7] { "2010", "2011", "2012", "2013", "2014", "2015", "2016" };
ViewBag.yLabels = yLabels;
return View();
}