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
51
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
200
Bring your chatbots to production
savelee
0
110
Improve your customer care by building an AI platform with the use of Google Cloud
savelee
0
390
How to build & measure natural conversations for the Google Assistant
savelee
0
150
Contact Center AI
savelee
3
290
Digital Wednesday
savelee
2
150
Other Decks in Technology
See All in Technology
クラウド開発の舞台裏とSRE文化の醸成 / SRE NEXT 2025 Lunch Session
kazeburo
1
580
How to Quickly Call American Airlines®️ U.S. Customer Care : Full Guide
flyaahelpguide
0
240
Copilot coding agentにベットしたいCTOが開発組織で取り組んだこと / GitHub Copilot coding agent in Team
tnir
0
190
IPA&AWSダブル全冠が明かす、人生を変えた勉強法のすべて
iwamot
PRO
2
230
SRE with AI:実践から学ぶ、運用課題解決と未来への展望
yoshiiryo1
0
310
Talk to Someone At Delta Airlines™️ USA Contact Numbers
travelcarecenter
0
160
「Chatwork」のEKS環境を支えるhelmfileを使用したマニフェスト管理術
hanayo04
1
400
SRE不在の開発チームが障害対応と 向き合った100日間 / 100 days dealing with issues without SREs
shin1988
2
2k
Contract One Engineering Unit 紹介資料
sansan33
PRO
0
6.9k
cdk initで生成されるあのファイル達は何なのか/cdk-init-generated-files
tomoki10
1
670
本当にわかりやすいAIエージェント入門
segavvy
1
340
組織内、組織間の資産保護に必要なアイデンティティ基盤と関連技術の最新動向
fujie
0
270
Featured
See All Featured
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
BBQ
matthewcrist
89
9.7k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
31
1.3k
Thoughts on Productivity
jonyablonski
69
4.7k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
Fantastic passwords and where to find them - at NoRuKo
philnash
51
3.3k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
Building Better People: How to give real-time feedback that sticks.
wjessup
367
19k
Keith and Marios Guide to Fast Websites
keithpitt
411
22k
Designing Experiences People Love
moore
142
24k
Embracing the Ebb and Flow
colly
86
4.8k
Docker and Python
trallard
45
3.5k
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