X where a user is member of a group

Webix JS
1

Dear Webix support,

My compliments for this very nice framework.

I’ve got this very simple json dataset:

[{user: “Bill”, ADSgroup: “Domain users”},{ user: “Bill”, ADSgroup: “Application B”},{user: “Judy”, ADSgroup: “Domain users”},{user: "Judy”, ADSgroup: “Application A”},{user: “John”, ADSgroup: “Domain users”},{user: “John”, ADSgroup: “Application B”},{user: “John”, ADSgroup: “Printer 45”}

And I’d like to pivot it with the users horizontal and groups vertical and put only a sign (an X will do) in the location where the two match. Like in this simple example (see picture below).


Could this be done with your Pivot widget? And if so how do I put the X only there where it should be.

Kind regards,

Frans

2

Hi,

Unfortunately Pivot can’t be used here.
It possible to use grouping in datatable to convert data in the necessary way, but it still will require quite a lot of coding, and values of columns will be hardcoded.

http://webix.com/snippet/9cd380e8

3

Thank you Maksim,

This is a very good alternative.

Kind regards,

Frans

4

Dear Maksim,

Would it be posible to turn the headers in this example?
I’ve tried to add the style part in the html but I don’t know how and what to incorporate in the javascript part.

Kind regards,

Frans Erich

5

I ment turning the header text vertical.

6

This feature is supported by pro version
http://docs.webix.com/datatable__headers_footers.html#rotatedheaderfooter

http://webix.com/snippet/b1a89ae1