Creating Dynamic Matrix Dashboard

0
I want to create a dashboard where both rows and columns are dynamic and displayed in a matrix format. For example: skills  a       b       c 1       yes    no    yes 2       no     yes   no 3      no     yes   no Please guide me on what type of data structure or entity I should use to achieve this setup, how the matrix will update in real time when selections like Yes or No are made directly in the dashboard, and the best approach to design it so that it remains flexible for future changes.
asked
2 answers
0

Use Dynamic Data Grid 

 

Reference Link : https://marketplace.mendix.com/link/component/216495 

answered
0

You can are describing a pivot (matrix) table. You can store the data in a normalized entity as follows:

 

NormalizedEntity

skill person value1   a   yes

1   b   no

1   c   yes

2   a   no

2   b   yes

2   c   no

3   a   no

3   b   yes

3   c   no

 

Then you can use a widget to display normalized table data in a matrix format.

 

check this project:

https://github.com/mendixlabs/widget-test-projects/blob/master/projects/matrix/DynamicTableTest.mpk

 

Also "Dynamic Data Grid" suggested above seems to be a good alternative. Here you can see a sample page using Dynamic Data grid:

https://testtable-sandbox.mxapps.io/

 

answered