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
Beyond Kaniko: Navigating Unprivileged Container Image Creation
f30
0
130
ビズリーチが挑む メトリクスを活用した技術的負債の解消 / dev-productivity-con2025
visional_engineering_and_design
3
7.5k
What’s new in Android development tools
yanzm
0
310
Glacierだからってコストあきらめてない? / JAWS Meet Glacier Cost
taishin
1
160
改めてAWS WAFを振り返る~業務で使うためのポイント~
masakiokuda
2
250
NewSQLや分散データベースを支えるRaftの仕組み - 仕組みを理解して知る得意不得意
hacomono
PRO
2
130
AI時代の開発生産性を加速させるアーキテクチャ設計
plaidtech
PRO
3
150
スタートアップに選択肢を 〜生成AIを活用したセカンダリー事業への挑戦〜
nstock
0
170
マーケットプレイス版Oracle WebCenter Content For OCI
oracle4engineer
PRO
3
960
LangChain Interrupt & LangChain Ambassadors meetingレポート
os1ma
2
310
第4回Snowflake 金融ユーザー会 Snowflake summit recap
tamaoki
1
280
PO初心者が考えた ”POらしさ”
nb_rady
0
210
Featured
See All Featured
The Language of Interfaces
destraynor
158
25k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
950
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.7k
Bash Introduction
62gerente
613
210k
The Pragmatic Product Professional
lauravandoore
35
6.7k
Producing Creativity
orderedlist
PRO
346
40k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.4k
Gamification - CAS2011
davidbonilla
81
5.4k
Designing for Performance
lara
610
69k
Automating Front-end Workflow
addyosmani
1370
200k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
233
17k
How STYLIGHT went responsive
nonsquared
100
5.6k
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