Forum Discussion
Need Help on splitting/combining values
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)
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)
Thanks, I think I'm getting slightly closer. I don't seem to have a "rows" option, this might due to not having the last couple updates.
It did split well into additional columns, I'm hopin to maybe add these together on my chart axis, but it looks like right now it is still filtering by the hierarchy.
i think you missed one step there , you need to choose Rows in advanced than columns