Language
Login
Language Setting
X
English
日本語 [Japanese]
about this App
主要穀物生産高ピボットテーブル
useful
1
Loading...
/* This is a Example program to retrieve and display the data. Press the Run button on the right of the screen (described the behavior of the Example program below). Please create a new application rewrite this program work. */ var all_data; function initialize(){ all_data = new Array(); // データをLinkDataから取得 tmp_a_data = new Array(); $.each(LinkData.getWorks(), function(workKey, workValue) { $.each(LinkData.getFiles(workValue), function(fileKey, fileValue) { $.each(LinkData.getSubjects(workValue, fileValue), function(subjKey, subjValue) { var tmp_data = {} //tmp_data["id"] = subjValue; $.each(LinkData.getProperties(workValue, fileValue), function(propKey, propValue) { $.each(LinkData.getObjects(workValue, fileValue, subjValue, propValue), function(objKey, objValue) { if(propValue == "http://www.w3.org/2000/01/rdf-schema#label"){ tmp_data["Number"] = objValue; }else if(propValue == "http://www.geonames.org/ontology#countryCode"){ tmp_data["ContryCode"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s794i#category"){ tmp_data["Category"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s794i#value"){ tmp_data["Value"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s794i#period"){ tmp_data["Period"] = objValue; } }); }); tmp_a_data.push(tmp_data); }); }); }); //全データ all_data = tmp_a_data; var derivers = $.pivotUtilities.derivers; $("#output").pivotUI(all_data, { rows: ["Category"], cols: ["Period"], vals:["Value"], aggregatorName:"sum", effectsName: "Heatmap" }); }; window.onload = function() { $(function(){ initialize(); }); };
table.pvtTable { font-family:arial; font-size: 8pt; text-align: left; border-collapse: collapse; } table.pvtTable tr th, table.pvtTable tr th { background-color: #e6EEEE; border: 1px solid #CDCDCD; font-size: 8pt; padding: 5px; } table.pvtTable .pvtColLabel {text-align: center;} table.pvtTable .pvtTotalLabel {text-align: right;} table.pvtTable tr td { color: #3D3D3D; padding: 5px; background-color: #FFF; border: 1px solid #CDCDCD; vertical-align: top; text-align: right; } .pvtTotal, .pvtGrandTotal { font-weight: bold; } .pvtAxisContainer { border: 1px solid gray; background: #EEE; padding: 5px; min-width: 20px; min-height: 20px; } .pvtAxisContainer li { margin: 5px; padding: 5px; list-style-type: none; cursor:move; } .pvtHorizList li { display: inline; }
<div id="output" style="margin: 30px;"></div>
Preview
Input Data
ReadMe
Snapshots
LinkData Work
Table Data
Production of crops top15 countries in 2010
Contributor:Sayoko Shimoyama
Update:Sep 18, 2018
2639 Downloads, 4 Applications
Top 15 countries of production of crops in 2010.
barley_top15_2010
corn_top15_2010
oats_top15_2010
peanut_2010
peanut_top15_2010
potato_top15_2010
rice_top15_2010
rye_top15_2010
soybean_top15_2010
sweet_potato_top15_2010
wheat_top15_2010
[
]
Add LinkData work(LinkData)
Link http://app.linkdata.org/run/app1s415i?tab=readme
Initial content
http://code.jquery.com/jquery-1.8.3.min.js
jquery-ui-1.9.2.custom.min.js
pivot.js
Work
Add
Clear
insert work id or work name.