Extjs pivotgrid's depth data structure The Next CEO of Stack OverflowHow do I iterate over a JSON structure?Convert form data to JavaScript object with jQueryHow to get the data-id attribute?Explain ExtJS 4 event handlingHow does data binding work in AngularJS?JSON.stringify, avoid TypeError: Converting circular structure to JSONExtJs two or more grids on same pagedynamically creating multiple Sencha ExtJS stores from a single storeHow to pass variables and data from PHP to JavaScript?Facing issue in sessionStorage Proxy implementation in Ext JS Grid view
Variance of Monte Carlo integration with importance sampling
Man transported from Alternate World into ours by a Neutrino Detector
Why was Sir Cadogan fired?
Can this transistor (2n2222) take 6V on emitter-base? Am I reading datasheet incorrectly?
Trying to insert a background image via TikZ results in extra white-space around the corners
What is Decreasing Arithmetic progression?
Mathematica command that allows it to read my intentions
Finitely generated matrix groups whose eigenvalues are all algebraic
Another proof that dividing by 0 does not exist is it right?
Does int main() need a declaration on C++?
How to avoid supervisors with prejudiced views?
Can Sri Krishna be called 'a person'?
Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?
What does this strange code stamp on my passport mean?
Cannot restore registry to default in Windows 10?
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Why did early computer designers eschew integers?
Horror film about a man brought out of cryogenic suspension without a soul, around 1990
pgfplots: How to draw a tangent graph below two others?
Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?
Noise during hard braking
Is it possible to create a QR code using text?
Avoiding the "not like other girls" trope?
Fastest algorithm to decide whether a (always halting) TM accepts a general string
Extjs pivotgrid's depth data structure
The Next CEO of Stack OverflowHow do I iterate over a JSON structure?Convert form data to JavaScript object with jQueryHow to get the data-id attribute?Explain ExtJS 4 event handlingHow does data binding work in AngularJS?JSON.stringify, avoid TypeError: Converting circular structure to JSONExtJs two or more grids on same pagedynamically creating multiple Sencha ExtJS stores from a single storeHow to pass variables and data from PHP to JavaScript?Facing issue in sessionStorage Proxy implementation in Ext JS Grid view
Firstly take a look at the data I'm trying to show on the pivotgrid:https://api.myjson.com/bins/1a46si, as you can see the items should be nested based on "L1~L8", and the value it should display on the aggregate is the "SUM".
As an example, a "L1" item will have a value on L1, but L2~L8 will be empty, and its sum value is the sum of all its "children" (this calc is already being sent from the server, so the pivot grid only need to show it).
Right now im doing it like this:
xtype: 'pivotgrid',
scrollable: 'both',
matrix:
compactViewColumnWidth: 600,
textGrandTotalTpl: 'Value',
textRowLabels: 'Name',
viewLayoutType: 'compact',
store: 'myPivotStore',
leftAxis: [
dataIndex: 'NAME_L1'
,
dataIndex: 'NAME_L2'
,
dataIndex: 'NAME_L3'
,
dataIndex: 'NAME_L4'
,
dataIndex: 'NAME_L5'
,
dataIndex: 'NAME_L6'
,
dataIndex: 'NAME_L7'
,
dataIndex: 'NAME_L8'
],
aggregate:
dataIndex: 'SUM'
The problem is that the pivot grid is showing these data that don't have any value on L2~L8 as '(blank)', another problem is the aggregate summing its children, I already tried to get the SUM value of the record with a custom aggregator but I can't find the right record which corresponds to the current aggregate.
fiddle example: https://fiddle.sencha.com/#view/editor&fiddle/2qrf
Image result:
Do I need to change the way I'm mapping the model? Sorry if I wasn't clear enough.
javascript extjs pivot-grid
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
add a comment |
Firstly take a look at the data I'm trying to show on the pivotgrid:https://api.myjson.com/bins/1a46si, as you can see the items should be nested based on "L1~L8", and the value it should display on the aggregate is the "SUM".
As an example, a "L1" item will have a value on L1, but L2~L8 will be empty, and its sum value is the sum of all its "children" (this calc is already being sent from the server, so the pivot grid only need to show it).
Right now im doing it like this:
xtype: 'pivotgrid',
scrollable: 'both',
matrix:
compactViewColumnWidth: 600,
textGrandTotalTpl: 'Value',
textRowLabels: 'Name',
viewLayoutType: 'compact',
store: 'myPivotStore',
leftAxis: [
dataIndex: 'NAME_L1'
,
dataIndex: 'NAME_L2'
,
dataIndex: 'NAME_L3'
,
dataIndex: 'NAME_L4'
,
dataIndex: 'NAME_L5'
,
dataIndex: 'NAME_L6'
,
dataIndex: 'NAME_L7'
,
dataIndex: 'NAME_L8'
],
aggregate:
dataIndex: 'SUM'
The problem is that the pivot grid is showing these data that don't have any value on L2~L8 as '(blank)', another problem is the aggregate summing its children, I already tried to get the SUM value of the record with a custom aggregator but I can't find the right record which corresponds to the current aggregate.
fiddle example: https://fiddle.sencha.com/#view/editor&fiddle/2qrf
Image result:
Do I need to change the way I'm mapping the model? Sorry if I wasn't clear enough.
javascript extjs pivot-grid
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
For some reason, sencha fiddle don't work with pivotgrid -Unrecognized alias: widget.pivotgrid
– norbeq
Mar 22 at 21:41
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45
add a comment |
Firstly take a look at the data I'm trying to show on the pivotgrid:https://api.myjson.com/bins/1a46si, as you can see the items should be nested based on "L1~L8", and the value it should display on the aggregate is the "SUM".
As an example, a "L1" item will have a value on L1, but L2~L8 will be empty, and its sum value is the sum of all its "children" (this calc is already being sent from the server, so the pivot grid only need to show it).
Right now im doing it like this:
xtype: 'pivotgrid',
scrollable: 'both',
matrix:
compactViewColumnWidth: 600,
textGrandTotalTpl: 'Value',
textRowLabels: 'Name',
viewLayoutType: 'compact',
store: 'myPivotStore',
leftAxis: [
dataIndex: 'NAME_L1'
,
dataIndex: 'NAME_L2'
,
dataIndex: 'NAME_L3'
,
dataIndex: 'NAME_L4'
,
dataIndex: 'NAME_L5'
,
dataIndex: 'NAME_L6'
,
dataIndex: 'NAME_L7'
,
dataIndex: 'NAME_L8'
],
aggregate:
dataIndex: 'SUM'
The problem is that the pivot grid is showing these data that don't have any value on L2~L8 as '(blank)', another problem is the aggregate summing its children, I already tried to get the SUM value of the record with a custom aggregator but I can't find the right record which corresponds to the current aggregate.
fiddle example: https://fiddle.sencha.com/#view/editor&fiddle/2qrf
Image result:
Do I need to change the way I'm mapping the model? Sorry if I wasn't clear enough.
javascript extjs pivot-grid
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
Firstly take a look at the data I'm trying to show on the pivotgrid:https://api.myjson.com/bins/1a46si, as you can see the items should be nested based on "L1~L8", and the value it should display on the aggregate is the "SUM".
As an example, a "L1" item will have a value on L1, but L2~L8 will be empty, and its sum value is the sum of all its "children" (this calc is already being sent from the server, so the pivot grid only need to show it).
Right now im doing it like this:
xtype: 'pivotgrid',
scrollable: 'both',
matrix:
compactViewColumnWidth: 600,
textGrandTotalTpl: 'Value',
textRowLabels: 'Name',
viewLayoutType: 'compact',
store: 'myPivotStore',
leftAxis: [
dataIndex: 'NAME_L1'
,
dataIndex: 'NAME_L2'
,
dataIndex: 'NAME_L3'
,
dataIndex: 'NAME_L4'
,
dataIndex: 'NAME_L5'
,
dataIndex: 'NAME_L6'
,
dataIndex: 'NAME_L7'
,
dataIndex: 'NAME_L8'
],
aggregate:
dataIndex: 'SUM'
The problem is that the pivot grid is showing these data that don't have any value on L2~L8 as '(blank)', another problem is the aggregate summing its children, I already tried to get the SUM value of the record with a custom aggregator but I can't find the right record which corresponds to the current aggregate.
fiddle example: https://fiddle.sencha.com/#view/editor&fiddle/2qrf
Image result:
Do I need to change the way I'm mapping the model? Sorry if I wasn't clear enough.
javascript extjs pivot-grid
javascript extjs pivot-grid
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
edited Mar 22 at 22:49
Matheus Hatje
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
asked Mar 21 at 18:37
Matheus HatjeMatheus Hatje
427
427
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
For some reason, sencha fiddle don't work with pivotgrid -Unrecognized alias: widget.pivotgrid
– norbeq
Mar 22 at 21:41
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45
add a comment |
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
For some reason, sencha fiddle don't work with pivotgrid -Unrecognized alias: widget.pivotgrid
– norbeq
Mar 22 at 21:41
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
For some reason, sencha fiddle don't work with pivotgrid -
Unrecognized alias: widget.pivotgrid– norbeq
Mar 22 at 21:41
For some reason, sencha fiddle don't work with pivotgrid -
Unrecognized alias: widget.pivotgrid– norbeq
Mar 22 at 21:41
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45
add a comment |
0
active
oldest
votes
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287147%2fextjs-pivotgrids-depth-data-structure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287147%2fextjs-pivotgrids-depth-data-structure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you present in fiddle/ some image what you want to achieve? Do you want to aggregate all "SUM" parameters?
– norbeq
Mar 21 at 22:46
Updated with fiddle example, i "just" need a way to remove those (blank) field, i tried to make a label filter, for each leftAxis (!= '(blank)'), but doing this some other field disapeared too
– Matheus Hatje
Mar 22 at 11:13
For some reason, sencha fiddle don't work with pivotgrid -
Unrecognized alias: widget.pivotgrid– norbeq
Mar 22 at 21:41
I was getting this error too, try to load another pivot grid fiddle and then load mine on the same browser page, I added an image of the result.
– Matheus Hatje
Mar 22 at 22:45