Forum Discussion
Resolver IIVisualisation option that allows for text format data to be used as table/matric values.
Hi,
I'm trying to create a table visualisation that is all text values. The row and column headers are text, but then so are the value completing the table. For an illustration of my data see the image below:
My column headers are 'Departments'. Under each of those departments I want to list the 'Roles' within each department. My data is set-up so that each role only belongs in one department.
The table below is close to what I want but it is using 'First' value whereas I want it to list every value.
Thanks for suggestiosn .
maracles , Not very clear. But you can create measure using concatenatex and use that
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
concatenatex(Table, Table[Column], ",")
3 Replies
- amitchandak
Super User
maracles , Not very clear. But you can create measure using concatenatex and use that
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
concatenatex(Table, Table[Column], ",")
maraclesThanks amitchandak - sorry it wasn't clear. If this helps I'm trying to produce a Matrix like the below:
My data is in two tables:
1. Departments
2. Roles
The data relationshipis one to many, with each Role linking to only one Department, but each Department having many Roles.
I just figure out to have the Roles as the value in the table. Does ConcatenateX help in this scenario?
- maracles
amitchandak I have actually tried your solution and it is working. Is there though a way of getting each value on it's own row, rather than having them all in one row but with linebreaks?
For anyone else looking for this solution you can add Line Breaks with & UNICHAR(10)