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
160
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
Contact Center AI
savelee
0
200
Implementing a custom AI voice Assistant by streaming WebRTC to Dialogflow & Cloud Speech
savelee
3
2k
ML & Chatbots workshop
savelee
1
160
Bring your chatbots to production
savelee
0
80
Improve your customer care by building an AI platform with the use of Google Cloud
savelee
0
280
How to build & measure natural conversations for the Google Assistant
savelee
0
120
Contact Center AI
savelee
3
230
Digital Wednesday
savelee
2
110
The future of customer care
savelee
3
150
Other Decks in Technology
See All in Technology
フルリモートワークはエンジニアの夢を叶えたか? #cm_odyssey
mamohacy
2
600
GoとアクターモデルでES+CQRSを実践! / proto_actor_es_cqrs
ytake
1
150
ペパボのオブザーバビリティ研修2024 説明資料
kesompochy
0
1.1k
テスト・設計研修【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
170
データベース研修 DB基礎【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
210
AI研修【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
130
ここがすごいよ! AWS Systems Manager!
saichan11
0
1.8k
データ分析を支える技術 生成AI再入門
ishikawa_satoru
0
380
テストケースの自動生成に生成AIの導入を試みた話と生成AIによる今後の期待
shift_evolve
0
180
What if...? 처음부터 다시 LLM 어플리케이션을 개발한다면
huffon
0
1k
初中級者用如何使用backlog -VALE TUDOEDITION-
in0u
0
140
MySQLのロックの種類とその競合
yoku0825
6
1.6k
Featured
See All Featured
Dealing with People You Can't Stand - Big Design 2015
cassininazir
360
22k
Statistics for Hackers
jakevdp
792
220k
The Pragmatic Product Professional
lauravandoore
29
6.1k
Unsuck your backbone
ammeep
666
57k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
23
1.9k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
36
9.1k
Ruby is Unlike a Banana
tanoku
96
10k
A better future with KSS
kneath
231
17k
Facilitating Awesome Meetings
lara
46
5.8k
How To Stay Up To Date on Web Technology
chriscoyier
784
250k
How to name files
jennybc
67
96k
Atom: Resistance is Futile
akmur
261
25k
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