Forum Discussion
Solved
Need Help on splitting/combining values
I'm having a table of people, each with a value of how many projects they are working on. But the list contains duplicates when two people are working on it together, which is counted seperately. ...
ok i think it is easy :
- goto query editor
- select "ASsigned Person" column
- under "Split Column" in menu, choose "By Delimiter"
- Choose semicolor delimiter
- Click Advaced option and select "rows"
- click ok
and this will do, so in you graph, now you will get the data what you are looking for
- drop person on x axis and project id on value (and choose count as summarization)
are quotes (") part of your data or it is just put in sample.
Just a sample to show that Person 1 / Person 2 is together.