Query and visual to show an outer join situation

[shikaris]

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 B. I want a query and visualization that shows where people assigned to space A are sitting. So, this will include all spaces assigned to A plus spaces in B that is occupied by folks who are assigned to A.

I was thinking of visualization where space A slots are identified a color, the people who are assinged to space A are in a color, while space B slots are in a different color and people assigned to space other than A but sitting in A are in different color.

Is this possible?

[Syndicate_Admin]

you need to provide coordinates for your locations. that can be a building plan, or a blank square/rectangle.  But some sort of X/Y data is needed.

[Syndicate_Admin]

you can use Choropleth visuals for that. 

[shikaris]

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