福井県鯖江

工場出荷額ピボットテーブル

fullscreen

松本豊

ピボットテーブルJavascriptを使ってみました。 https://github.com/nicolaskruchten/pivottable

Rating

useful

Application

Play
JavaScript
CSS
HTML
ReadMe
Snapshots

/*
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();        
    });	
};

Initial content

Fork this app as your new one download

Web Search

Contributor Send Message	松本豊
Run count	356
Website
License
Fork count	0
Created date	Jul 15, 2013
Last update date	Jul 17, 2013

Input Data
Related Ideas

LinkData work list used as input data in this application.
You can change input data and execute application if you change the checkbox.

028　眼鏡・繊維・漆器の現況 Contributor: Sabae City Update: Jan 20, 2016
660 Downloads
,

2 Applications

Industrial_shipments
Add New Data

News Feed

linkdata.org に関するツイート

Publish your application as JavaScript

that mashes up the Linked Open Data

Application Information

工場出荷額ピボットテーブル

Application

News Feed