Forum Discussion
TAN_THOMAS
2 years agoFrequent Visitor
Matrix table not displaying all the values
I am trying to use matrix table to create a table visualisation. However, it is only displaying 1 row of data at a time instead of all the data values. This is my entire row of data that i want ...
danextian
2 years agoSuper User
All dimensions added to the value tile must be aggregated one way or another and are evaluated based on the intersection of rows and columns. The matrix visual doesnt know which row in Value 1 is the equivalent in Value2. The same thing happens if you do it in a pivot table in Excel. Your table should look something like below to be able split the values into rows:
The number columns goes to the row tile.