UI Builder Cross Reference Matrix

[nwilliams62]

Has anyone used UI Builder to create a cross reference matrix?  I'm just trying to think through the best way to do it.  What I mean by cross reference matrix is just a table with the column headers being one parameter, the rows being another and then the intersection being a value that matches the combination of the row/column.

I thought at first a pivot table would do but that only aggregates data.  I'm thinking I might need to use repeaters and text elements?

[RubenBecerra]

I know you didn't get an answer here, but were you able to create your matrix? I'm working on a project right now and this is exactly what we are trying to accomplish as well. We're working on creating a custom widget, but wondering if this might be easier.

[nwilliams62]

Here is what I did:
Data:  I used a data transform to get my data in the form {headers:[], leftHeaders:[], data:[]} where data contains the header and left header that it goes with.

UI: I built my table  in two parts.  The header is a repeater that repeats the headers array.  The data section repeats twice...first for the header array then for the left header array.  I then used the data array by searching it for the current header, left header values to put actual values on the chart.