Forum Discussion

shikaris's avatar
shikaris
Regular Visitor
2 years ago

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 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?

Need Help

3 Replies

    • shikaris's avatar
      shikaris
      Regular Visitor
      2 years ago

      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 Kingdom20S100
      Animal Kingdom20S101
      Animal Kingdom20S102
      Animal Kingdom20S103
      Animal Kingdom20S104
      Animal Kingdom20S105
      Animal Kingdom20S106
      Animal Kingdom20S107
      Animal Kingdom20S108
      Animal Kingdom20S109
      Animal Kingdom20S110
      Animal Kingdom20S111
      Animal Kingdom20S112
      Animal Kingdom20S113
      Animal Kingdom20S114
      Animal Kingdom20S115
      Zootopia20N100

       

      NeighborhoodLast NameFirst Name

      Animal KingdomOliverAdams
      Animal KingdomLiamAnderson
      Animal KingdomWilliamBaker
      Animal KingdomNoahBrown
      Animal KingdomElijahClark
      Animal KingdomJamesDavis
      Animal KingdomBenjaminEdwards
      Animal KingdomLucasFisher
      Animal KingdomMasonGarcia
      Animal KingdomEthanGonzalez
      Animal KingdomAlexanderHarris
      Animal KingdomHenryJackson
      Animal KingdomMichaelJohnson
      Animal KingdomDanielLee
      Animal KingdomJacksonMiller
      Animal KingdomAadenMoore
      Animal KingdomOwenNelson
      ZootopiaSamuelParker

       

      NeighborhoodAnimal Kingdom    
      SeatMonTueWedThuFri
      20S100Oliver AdamsOliver AdamsOliver AdamsOliver Adams 
      20S101Liam AndersonLiam AndersonLiam AndersonLiam Anderson 
      20S102William BakerWilliam BakerWilliam BakerWilliam Baker 
      20S103Noah BrownNoah BrownNoah BrownNoah Brown 
      20S104Elijah ClarkElijah ClarkElijah ClarkElijah Clark 
      20S105James DavisJames DavisJames DavisJames Davis 
      20S106Benjamin EdwardsBenjamin EdwardsBenjamin EdwardsBenjamin Edwards 
      20S107Lucas FisherLucas FisherLucas FisherLucas Fisher 
      20S108Mason GarciaMason GarciaMason GarciaMason Garcia 
      20S109Ethan GonzalezEthan GonzalezEthan GonzalezEthan Gonzalez 
      20S110Alexander HarrisAlexander HarrisAlexander HarrisAlexander Harris 
      20S111Henry JacksonHenry JacksonHenry JacksonHenry Jackson 
      20S112Michael JohnsonMichael JohnsonMichael JohnsonMichael Johnson 
      20S113Daniel LeeDaniel LeeDaniel LeeDaniel Lee 
      20S114Jackson MillerJackson MillerJackson MillerJackson Miller 
      20S115  Samuel Parker Samuel Parker
      20N100 Owen Nelson Owen Nelson 
      20W100 Aaden Moore Aaden Moore 
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    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.