Language
Login
Language Setting
X
English
日本語 [Japanese]
about this App
工場出荷額ピボットテーブル
useful
3
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["id"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s820i#classification"){ tmp_data["Classification"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s820i#year"){ tmp_data["Year"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s820i#Number%20of%20establishments"){ tmp_data["NumOfEstablishments"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s820i#Number%20of%20employees"){ tmp_data["NumOfEmployees"] = objValue; }else if(propValue == "http://linkdata.org/property/rdf1s820i#hipment%20value"){ tmp_data["HipmentValue"] = objValue; } }); }); tmp_a_data.push(tmp_data); }); }); }); //全データ all_data = tmp_a_data; var derivers = $.pivotUtilities.derivers; $("#output").pivotUI(all_data, { rows: ["Classification"], cols: ["Year"], vals:["NumOfEstablishments"], 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
028 眼鏡・繊維・漆器の現況
Contributor:Sabae City
Update:Jan 20, 2016
668 Downloads, 2 Applications
Industrial_shipments
Add LinkData work(LinkData)
Link http://app.linkdata.org/run/app1s406i?tab=readme
Initial content
http://code.jquery.com/jquery-1.8.3.min.js
jquery-ui-1.9.2custom.min.js
pivot.js
Work
Add
Clear
insert work id or work name.