ピボットチャート

PivotChartFlexChartコントロールの拡張です。これを使用するには、2つのコンポーネントを接続するためにPivotChart.itemsSourceプロパティを PivotEngineのインスタンスに設定するだけです。以下のPivotChartには、各人および各費用の金額が表示されます。

import 'bootstrap.css'; import '@mescius/wijmo.styles/wijmo.css'; import './styles.css'; import * as wjOlap from '@mescius/wijmo.olap'; import * as wjInput from '@mescius/wijmo.input'; import '@mescius/wijmo.chart.render'; import { getData } from './data'; // document.readyState === 'complete' ? init() : window.onload = init; // function init() { // // initialize pivot engine var ngChart = new wjOlap.PivotEngine({ autoGenerateFields: false, itemsSource: getData(), fields: [ { binding: 'buyer', header: '担当者' }, { binding: 'type', header: '分類' }, { binding: 'amount', header: '金額' } ], valueFields: ['金額'], rowFields: ['担当者', '分類'], }); ngChart.fields.getField('金額').format = 'c0'; // customize field // // show the chart var pivotChart = new wjOlap.PivotChart('#pivotChart', { itemsSource: ngChart, showTitle: true, showLegend: 'Always' }); // // allow users to customize the chart type var cmbChartType = new wjInput.ComboBox('#chartType', { textChanged: function (s, e) { pivotChart.chartType = 'Column,Bar,Line,Area,Pie'.split(',')[s.selectedIndex]; }, itemsSource: '縦棒,横棒,折れ線,面,円'.split(',') }); // // allow users to customize the chart legend var cmbShowLegend = new wjInput.ComboBox('#showLegend', { textChanged: function (s, e) { pivotChart.showLegend = s.selectedIndex; }, itemsSource: '常に表示,表示しない,系列が複数の場合に表示'.split(',') }); // // // toggle chart title document.getElementById('chartTitle').addEventListener('click', function (e) { pivotChart.showTitle = e.target.checked; }); // // export the chart to an image document.getElementById('export').addEventListener('click', function (e) { if (e.target instanceof HTMLButtonElement) { var ext = e.target.textContent.trim(); pivotChart.saveImageToFile('FlexChart.' + ext); } }); // }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>MESCIUS Wijmo OLAP Pivot Chart Overview</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.21.5/system.src.js" integrity="sha512-skZbMyvYdNoZfLmiGn5ii6KmklM82rYX2uWctBhzaXPxJgiv4XBwJnFGr5k8s+6tE1pcR1nuTKghozJHyzMcoA==" crossorigin="anonymous"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div class="container-fluid"> <div id="pivotChart"></div> <label> チャート種別 <input id="chartType"> </label> <br/> <label> 凡例を表示 <input id="showLegend"> </label> <br/> <label> タイトルを表示 <input id="chartTitle" type="checkbox" checked="checked"> </label> <div id="export"> エクスポート <button class="btn btn-default">PNG</button> <button class="btn btn-default">JPEG</button> <button class="btn btn-default">SVG</button> </div> </div> </body> </html>
// get the raw data export function getData() { var yr = new Date().getFullYear(); return [{ date: new Date(yr, 0, 1), buyer: '成宮 真紀', type: 'ビデオ', amount: 7400 }, { date: new Date(yr, 0, 15), buyer: '成宮 真紀', type: '食品', amount: 23500 }, { date: new Date(yr, 0, 17), buyer: '山本 雅治', type: '家電', amount: 2000 }, { date: new Date(yr, 0, 21), buyer: '加藤 泰江', type: '本', amount: 12500 }, { date: new Date(yr, 1, 2), buyer: '成宮 真紀', type: '食品', amount: 23500 }, { date: new Date(yr, 1, 20), buyer: '加藤 泰江', type: '音楽', amount: 2000 }, { date: new Date(yr, 1, 25), buyer: '加藤 泰江', type: 'パソコン', amount: 12500 }, ]; }
.wj-pivotchart { margin: auto; max-width: 600px; } .wj-pivotchart .wj-flexchart { border: none; height: 300px; } body { margin-bottom: 48pt; }
(function (global) { System.config({ transpiler: 'plugin-babel', babelOptions: { es2015: true }, meta: { '*.css': { loader: 'css' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { 'jszip': 'npm:jszip/dist/jszip.js', '@mescius/wijmo': 'npm:@mescius/wijmo/index.js', '@mescius/wijmo.input': 'npm:@mescius/wijmo.input/index.js', '@mescius/wijmo.styles': 'npm:@mescius/wijmo.styles', '@mescius/wijmo.cultures': 'npm:@mescius/wijmo.cultures', '@mescius/wijmo.chart': 'npm:@mescius/wijmo.chart/index.js', '@mescius/wijmo.chart.analytics': 'npm:@mescius/wijmo.chart.analytics/index.js', '@mescius/wijmo.chart.animation': 'npm:@mescius/wijmo.chart.animation/index.js', '@mescius/wijmo.chart.annotation': 'npm:@mescius/wijmo.chart.annotation/index.js', '@mescius/wijmo.chart.finance': 'npm:@mescius/wijmo.chart.finance/index.js', '@mescius/wijmo.chart.finance.analytics': 'npm:@mescius/wijmo.chart.finance.analytics/index.js', '@mescius/wijmo.chart.hierarchical': 'npm:@mescius/wijmo.chart.hierarchical/index.js', '@mescius/wijmo.chart.interaction': 'npm:@mescius/wijmo.chart.interaction/index.js', '@mescius/wijmo.chart.radar': 'npm:@mescius/wijmo.chart.radar/index.js', '@mescius/wijmo.chart.render': 'npm:@mescius/wijmo.chart.render/index.js', '@mescius/wijmo.chart.webgl': 'npm:@mescius/wijmo.chart.webgl/index.js', '@mescius/wijmo.chart.map': 'npm:@mescius/wijmo.chart.map/index.js', '@mescius/wijmo.gauge': 'npm:@mescius/wijmo.gauge/index.js', '@mescius/wijmo.grid': 'npm:@mescius/wijmo.grid/index.js', '@mescius/wijmo.grid.detail': 'npm:@mescius/wijmo.grid.detail/index.js', '@mescius/wijmo.grid.filter': 'npm:@mescius/wijmo.grid.filter/index.js', '@mescius/wijmo.grid.search': 'npm:@mescius/wijmo.grid.search/index.js', '@mescius/wijmo.grid.grouppanel': 'npm:@mescius/wijmo.grid.grouppanel/index.js', '@mescius/wijmo.grid.multirow': 'npm:@mescius/wijmo.grid.multirow/index.js', '@mescius/wijmo.grid.transposed': 'npm:@mescius/wijmo.grid.transposed/index.js', '@mescius/wijmo.grid.transposedmultirow': 'npm:@mescius/wijmo.grid.transposedmultirow/index.js', '@mescius/wijmo.grid.pdf': 'npm:@mescius/wijmo.grid.pdf/index.js', '@mescius/wijmo.grid.sheet': 'npm:@mescius/wijmo.grid.sheet/index.js', '@mescius/wijmo.grid.xlsx': 'npm:@mescius/wijmo.grid.xlsx/index.js', '@mescius/wijmo.grid.selector': 'npm:@mescius/wijmo.grid.selector/index.js', '@mescius/wijmo.grid.cellmaker': 'npm:@mescius/wijmo.grid.cellmaker/index.js', '@mescius/wijmo.nav': 'npm:@mescius/wijmo.nav/index.js', '@mescius/wijmo.odata': 'npm:@mescius/wijmo.odata/index.js', '@mescius/wijmo.olap': 'npm:@mescius/wijmo.olap/index.js', '@mescius/wijmo.rest': 'npm:@mescius/wijmo.rest/index.js', '@mescius/wijmo.pdf': 'npm:@mescius/wijmo.pdf/index.js', '@mescius/wijmo.pdf.security': 'npm:@mescius/wijmo.pdf.security/index.js', '@mescius/wijmo.viewer': 'npm:@mescius/wijmo.viewer/index.js', '@mescius/wijmo.xlsx': 'npm:@mescius/wijmo.xlsx/index.js', '@mescius/wijmo.undo': 'npm:@mescius/wijmo.undo/index.js', '@mescius/wijmo.interop.grid': 'npm:@mescius/wijmo.interop.grid/index.js', '@mescius/wijmo.touch': 'npm:@mescius/wijmo.touch/index.js', '@mescius/wijmo.cloud': 'npm:@mescius/wijmo.cloud/index.js', '@mescius/wijmo.barcode': 'npm:@mescius/wijmo.barcode/index.js', '@mescius/wijmo.barcode.common': 'npm:@mescius/wijmo.barcode.common/index.js', '@mescius/wijmo.barcode.composite': 'npm:@mescius/wijmo.barcode.composite/index.js', '@mescius/wijmo.barcode.specialized': 'npm:@mescius/wijmo.barcode.specialized/index.js', 'jszip': 'npm:jszip/dist/jszip.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'css': 'npm:systemjs-plugin-css/css.js', 'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js', 'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js' }, // packages tells the System loader how to load when no filename and/or no extension packages: { src: { defaultExtension: 'js' }, "node_modules": { defaultExtension: 'js' }, } }); })(this);