Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Pivot Grid Demo
Search
Lee Boonstra
February 11, 2016
Technology
1
170
Pivot Grid Demo
Ext JS - premium tier - pivot grid demo
Lee Boonstra
February 11, 2016
Tweet
Share
More Decks by Lee Boonstra
See All by Lee Boonstra
AI Workshop
savelee
0
67
Contact Center AI
savelee
0
250
Implementing a custom AI voice Assistant by streaming WebRTC to Dialogflow & Cloud Speech
savelee
3
2.4k
ML & Chatbots workshop
savelee
1
210
Bring your chatbots to production
savelee
0
120
Improve your customer care by building an AI platform with the use of Google Cloud
savelee
0
410
How to build & measure natural conversations for the Google Assistant
savelee
0
150
Contact Center AI
savelee
3
290
Digital Wednesday
savelee
2
160
Other Decks in Technology
See All in Technology
「どこから読む?」コードとカルチャーに最速で馴染むための実践ガイド
zozotech
PRO
0
510
5分でカオスエンジニアリングを分かった気になろう
pandayumi
0
250
Platform開発が先行する Platform Engineeringの違和感
kintotechdev
4
580
【初心者向け】ローカルLLMの色々な動かし方まとめ
aratako
7
3.5k
ブロックテーマ時代における、テーマの CSS について考える Toro_Unit / 2025.09.13 @ Shinshu WordPress Meetup
torounit
0
130
株式会社ログラス - 会社説明資料【エンジニア】/ Loglass Engineer
loglass2019
4
64k
下手な強制、ダメ!絶対! 「ガードレール」を「檻」にさせない"ガバナンス"の取り方とは?
tsukaman
2
450
はじめてのOSS開発からみえたGo言語の強み
shibukazu
1
700
DDD集約とサービスコンテキスト境界との関係性
pandayumi
3
290
ハードウェアとソフトウェアをつなぐ全てを内製している企業の E2E テストの作り方 / How to create E2E tests for a company that builds everything connecting hardware and software in-house
bitkey
PRO
1
150
新規プロダクトでプロトタイプから正式リリースまでNext.jsで開発したリアル
kawanoriku0
1
160
Rustから学ぶ 非同期処理の仕組み
skanehira
1
140
Featured
See All Featured
The Invisible Side of Design
smashingmag
301
51k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
[RailsConf 2023] Rails as a piece of cake
palkan
57
5.8k
Java REST API Framework Comparison - PWX 2021
mraible
33
8.8k
Gamification - CAS2011
davidbonilla
81
5.4k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
23
1.4k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
358
30k
Put a Button on it: Removing Barriers to Going Fast.
kastner
60
4k
Why You Should Never Use an ORM
jnunemaker
PRO
59
9.5k
Build your cross-platform service in a week with App Engine
jlugia
231
18k
Testing 201, or: Great Expectations
jmmastey
45
7.7k
Git: the NoSQL Database
bkeepers
PRO
431
66k
Transcript
Pivot Grid
Pivot Grid? • Famous feature in Excel. • Tabulate & summarize data
in your spreadsheet.
A pivot grid in Sencha… • Multi dimensional grid • For data
Analytics, a data summarization tool
Pivot Grid • Pivot Grids package – A Power UI component
• Ext JS 5 & Ext JS 6 classic • Ships with locales • Power UI components are part of premium tiers. • Roadmap: More power UI components!
Some things aren’t visible in a normal grid… • What is
John Doe's total order amount? • What are the total order amounts by country? • How did sales people perform in a specific year?
Pivot Grid – Axes & Aggregator Left Axis Top Axis
Aggregator
Axes Configurations
Aggregator Configurations Examples: • Sum • Average • Min •
Max • Count • Own?
Various configurations • Filter • Configurator • Drill down •
Stateful
How to setup? • Download the packages from the support
portal • Copy the packages into “packages” folder • Require the packages in “app.json” • http://docs.sencha.com/extjs/6.0/6.0.0-classic/#!/api/Ext.pivot.Grid • http://docs.sencha.com/extjs/6.0/components/pivot_grid.html • http://examples.sencha.com/extjs/6.0.0/examples/kitchensink/ #pivot-grids
Exporter plugin • Export Pivot Grid & Classic grid data to
Excel • Exports as XML • Example: http://ladysign-apps.com/senchaplaces/
Exporter plugin plugins: [ { ptype: 'gridexporter', pluginId: 'exporter' }],
https://github.com/savelee/senchaplaces/blob/master/ app/view/grid/Excel.js
Exporter plugin plugins: [ { ptype: 'gridexporter', pluginId: 'exporter' }],
https://github.com/savelee/senchaplaces/blob/master/ app/view/grid/Excel.js
Resources h"p://video.sencha.com/watch/bqWyUpT1YRGsPlTKMKLq-g