Forum Discussion
OnDaRoXx
4 years agoNew Member
Chord diagram from raw data
Hi all,
I am trying to represent relationships between my data using a Chord Diagram and unfortunately I can't come up with a solution. Here is my problem description:
I have a table of people who were in different places I now want to show the location and the NUMBER of people who share the locations. The following example data:
| Name | Place | |
| Person A | X | |
| Person A | Y | |
| Person A | V | |
| Person B | V | |
| Person B | Y | |
| Person B | X | |
| Person B | Z | |
| Person C | X | |
| Person C | Z |
Thank you for your help!
see attached. Note the Power Query transforms.