Forum Discussion
Query and visual to show an outer join situation
I have two sets of data - one is list of people who are assigned to a space. The other is list of people sitting in a space. Sometimes if the space is full people assigned to space A sit in space...
you can use Choropleth visuals for that.
Please see the data and a sample output I am looking (3rd table). The two seats in different color belong to a different neighborhood and two people in different color are people from a different neighborhood sitting in the current neighborhood. How does Choropleth help here
NeighborhoodSeat
| Animal Kingdom | 20S100 |
| Animal Kingdom | 20S101 |
| Animal Kingdom | 20S102 |
| Animal Kingdom | 20S103 |
| Animal Kingdom | 20S104 |
| Animal Kingdom | 20S105 |
| Animal Kingdom | 20S106 |
| Animal Kingdom | 20S107 |
| Animal Kingdom | 20S108 |
| Animal Kingdom | 20S109 |
| Animal Kingdom | 20S110 |
| Animal Kingdom | 20S111 |
| Animal Kingdom | 20S112 |
| Animal Kingdom | 20S113 |
| Animal Kingdom | 20S114 |
| Animal Kingdom | 20S115 |
| Zootopia | 20N100 |
NeighborhoodLast NameFirst Name
| Animal Kingdom | Oliver | Adams |
| Animal Kingdom | Liam | Anderson |
| Animal Kingdom | William | Baker |
| Animal Kingdom | Noah | Brown |
| Animal Kingdom | Elijah | Clark |
| Animal Kingdom | James | Davis |
| Animal Kingdom | Benjamin | Edwards |
| Animal Kingdom | Lucas | Fisher |
| Animal Kingdom | Mason | Garcia |
| Animal Kingdom | Ethan | Gonzalez |
| Animal Kingdom | Alexander | Harris |
| Animal Kingdom | Henry | Jackson |
| Animal Kingdom | Michael | Johnson |
| Animal Kingdom | Daniel | Lee |
| Animal Kingdom | Jackson | Miller |
| Animal Kingdom | Aaden | Moore |
| Animal Kingdom | Owen | Nelson |
| Zootopia | Samuel | Parker |
| Neighborhood | Animal Kingdom | ||||
| Seat | Mon | Tue | Wed | Thu | Fri |
| 20S100 | Oliver Adams | Oliver Adams | Oliver Adams | Oliver Adams | |
| 20S101 | Liam Anderson | Liam Anderson | Liam Anderson | Liam Anderson | |
| 20S102 | William Baker | William Baker | William Baker | William Baker | |
| 20S103 | Noah Brown | Noah Brown | Noah Brown | Noah Brown | |
| 20S104 | Elijah Clark | Elijah Clark | Elijah Clark | Elijah Clark | |
| 20S105 | James Davis | James Davis | James Davis | James Davis | |
| 20S106 | Benjamin Edwards | Benjamin Edwards | Benjamin Edwards | Benjamin Edwards | |
| 20S107 | Lucas Fisher | Lucas Fisher | Lucas Fisher | Lucas Fisher | |
| 20S108 | Mason Garcia | Mason Garcia | Mason Garcia | Mason Garcia | |
| 20S109 | Ethan Gonzalez | Ethan Gonzalez | Ethan Gonzalez | Ethan Gonzalez | |
| 20S110 | Alexander Harris | Alexander Harris | Alexander Harris | Alexander Harris | |
| 20S111 | Henry Jackson | Henry Jackson | Henry Jackson | Henry Jackson | |
| 20S112 | Michael Johnson | Michael Johnson | Michael Johnson | Michael Johnson | |
| 20S113 | Daniel Lee | Daniel Lee | Daniel Lee | Daniel Lee | |
| 20S114 | Jackson Miller | Jackson Miller | Jackson Miller | Jackson Miller | |
| 20S115 | Samuel Parker | Samuel Parker | |||
| 20N100 | Owen Nelson | Owen Nelson | |||
| 20W100 | Aaden Moore | Aaden Moore |