Pivot table related questions and problems

Webix JS
1

Hi,

First of all I would like to thank the developers for this great javascript library. I like it a lot. I have some questions and a few problems with the pivot table component.

The questions:

  1. Is there any way to display subtotals and grand totals in the pivot table? I didn’t find such functionality so I tried to modify the underlying datatable’s footer but that didn’t work.
  2. If there are multiple row fields, is it possible to specify if the pivot table should be displayed collapsed or expanded by default?

The problems:

  1. I noticed that if a field has an underscore in its name then it can’t be used as a value field. (The pivot table won’t display and a javascript error is thrown.) It’s not a major problem, it can be worked around I just wanted you to know.
  2. I have a dataset with about 3000 row. I have one row field (name), one column field (month) and one value field which is summed. Everything works fine. If I add another column field (year) above the month field suddenly only March appears, January and February is not displayed. I created a short video (9 seconds) to illustrate the problem: http://d.pr/v/6auE

Can you help? Thanks in advance!

Regards,

Peter

2

  1. There is no extra footer row, but the the group parent row will contain sub-total for all sub-rows. Can you share a sketch of the desired result view ?

  2. Currently it is not possible. I don’t think that such setting is really necessary in the Settings GUI. We can add it to API though, so when you are settings configuration of the pivot through API you will be able to specify the per-level open|expand settings.

Problems

  1. Confirmed. Fixed version of pivot will be available on Monday.

  2. We will investigate the issue. From video it looks as a bug, but I can’t reconstruct it locally so far. If you can share the data from the problematic pivot - please send it to the support@webix.com

3

Hi Maksim,

Thanks for your reply. I am sending you the requested sketch and data set in an email.
If you could add the functionality to display the pivot collapsed to the API I would be grateful but I would completely understand if that’s too much work for only one user.

Regards,

Peter

4

Please try to use the update package - it must resolve reported problems
http://webix.com/pivot/download.html

5

I downloaded this package but don’t see any grand totals for the entire grid. Am I missing something?

6

Pivot still doesn’t support grand-total row. The above update contains only fixes for technical issues.

7

Hello, i was trying the samples of the “Loading Data from URL”, it doesn’t work …
but the inline form works fine!

But i really need to see this work, because i’ve got a project wich i must pull out of a database some data and them show it in PIVOT!

I found this framework very very usufull and i would like to know what the problem might be?

I’ve downloaded the latest pivot!

8

Do you have problems with default loading sample, or with your own code ? In second case please provide any kind of sample where issue can be checked.

9

Hi Maksim,

I have some further questions/remarks:

  • Is it possible to set the pivot table nr. format? For example to use format: webix.i18n.numberFormat anywhere?
  • Is it possible to set a loading screen for a pivot table? Turning it on for its datatable does not work.
  • If there is both a pivot chart and a pivot table on the same page, their configuration panels do not work correctly. The pivot table’s panel works fine, but when I open the chart’s panel it opens the pivot table’s panel anyway but no fields are displayed. This is not a problem for me I just wanted to let you know in case you want to look into it.

Thanks!

Peter

10

Problem with chart and table pivots on the same page will be fixed in the next update ( most probably it will be available on the next week )

We plan to include ability to define custom formatting and sorting for columns as well.

As for loading screen - can you provide some more info, how you want it to behave ?

11

Hi Maksim,

Thanks for your reply. Regarding the loading screen:

	$$('pivot').$$('data').attachEvent('onBeforeLoad', function() {
		this.showOverlay('Loading data...');
	});
	
	$$('pivot').$$('data').attachEvent('onAfterLoad', function() {
		this.hideOverlay();
	});

If such a solution would work it would be great. But it’s not a priority. If you plan to add this anyway then do it. If not, I can live without it.

Thanks!

Peter