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
74
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
420
How to build & measure natural conversations for the Google Assistant
savelee
0
150
Contact Center AI
savelee
3
300
Digital Wednesday
savelee
2
160
Other Decks in Technology
See All in Technology
Dylib Hijacking on macOS: Dead or Alive?
patrickwardle
0
310
現場データから見える、開発生産性の変化コード生成AI導入・運用のリアル〜 / Changes in Development Productivity and Operational Challenges Following the Introduction of Code Generation AI
nttcom
0
260
HR Force における DWH の併用事例 ~ サービス基盤としての BigQuery / 分析基盤としての Snowflake ~@Cross Data Platforms Meetup #2「BigQueryと愉快な仲間たち」
ryo_suzuki
0
230
ニッポンの人に知ってもらいたいGISスポット
sakaik
0
170
防災デジタル分野での官民共創の取り組み (2)DIT/CCとD-CERTについて
ditccsugii
0
310
All About Sansan – for New Global Engineers
sansan33
PRO
1
1.2k
ガバメントクラウドの概要と自治体事例(名古屋市)
techniczna
3
240
ガバメントクラウド(AWS)へのデータ移行戦略の立て方【虎の巻】 / 20251011 Mitsutosi Matsuo
shift_evolve
PRO
2
200
サイバーエージェント流クラウドコスト削減施策「みんなで金塊堀太郎」
kurochan
4
2.1k
Railsの話をしよう
yahonda
0
160
プロダクトのコードから見るGoによるデザインパターンの実践 #go_night_talk
bengo4com
1
2.6k
AIツールでどこまでデザインを忠実に実装できるのか
oikon48
6
3.5k
Featured
See All Featured
For a Future-Friendly Web
brad_frost
180
10k
What's in a price? How to price your products and services
michaelherold
246
12k
Java REST API Framework Comparison - PWX 2021
mraible
34
8.9k
The Straight Up "How To Draw Better" Workshop
denniskardys
238
140k
Thoughts on Productivity
jonyablonski
70
4.9k
Principles of Awesome APIs and How to Build Them.
keavy
127
17k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
Why You Should Never Use an ORM
jnunemaker
PRO
59
9.6k
The Language of Interfaces
destraynor
162
25k
Git: the NoSQL Database
bkeepers
PRO
431
66k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
34
2.3k
Designing for Performance
lara
610
69k
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