allocating a location to each component of a table (over time)

[tilldunk]

I got a table with some components (columns) and their values change over time(-column). Now I am wondering if I can allocate a generall location to each component. My idea was to create a second table with the components (columns) and their generall location and then (somehow) merge both tables by query editor, so firstly I can depict the values over the course of time (first visualization) and secondly I can visualize the location of each component (map visualization). Both visualizations should then be connected.

Is that somehow possible to realize? Thank you for your help

[v-huizhn-msft]

Hi @tilldunk,

Please share your sample table, so that we can see the data structure. Based on your description, you create a map visualization and another one, what visual did you use for another one? Please share more details, so that we can post detailed solution.

Best Regards,
Angelia

[tilldunk]

First of all, thanks for your quick reply.

I got two sample tables (1st table, 2nd table). I want to allocate a generall location to each of those three components (1. comp, 2. comp, 3. comp) so I can generate two visualizations (1st visualization: area chart with values over time; 2nd visualization: map, where you can find out the location of each component). 

Is it possible to connect both tables so each component is related to a generall location? Thanks for your help 

1st table: component values over time2nd table: allocated locations1st visualization: values over time (area chart)2nd visualization: location of each component (map)

[v-huizhn-msft]

Hi @tilldunk,

>>Is it possible to connect both tables so each component is related to a generall location? 

If my understanding is right, you want to connect the two tables. When you select 1.comp in map, the first visualization just display the 1.comp values over time, the wo visualizations effect each other, right? If it is, it is impossible. Because we create relationship between two table based on rows of each table, we can not find a common rows from both table. In addition, you want the 1.comp, 2.comp, 3.comp values in component field to filter the 1.comp column, 2.comp column, 3.comp column in Table1, we have so such a feature, you can create an idea here, you can also review this and vote it.

Best Regards,
Angelia

[Greg_Deckler]

Would need to see some data on how it is setup.

[tilldunk]

I got a table with some components (columns) and their values over time(-column). Now I am wondering how I can match them with a location. My idea was creating a new table with all components allocated to their location and subsequently (somehow) merge both tables with the query editor.

My goal is to visualize the component values over the course of time (first visualization) and additionally depict the location of each component an a map (second visualization) while both visualizations are connected.

Thank you