Forum Discussion
scatter plot multiple series
Hi all, I want to plot multiple series on the scatter plot visualization. Using data below as an example. Relating the temperature to % of transportation modes. I have data structured as below:
Table 1
| country ID | replicate | region | temp |
| 1 | 1 | north | 25 |
| 1 | 1 | south | 13 |
| 1 | 1 | east | 5 |
| 2 | 1 | north | 30 |
| 2 | 1 | south | 8 |
| 2 | 1 | east | 12 |
| 3 | 1 | north | 67 |
| 3 | 1 | south | 3 |
| 3 | 1 | east | 17 |
and another table. Both are connected via the ID column
Table 2
| country ID | transportation mode | % |
| 1 | car | 25 |
| 1 | bus | 68 |
| 1 | train | 7 |
| 2 | car | 13 |
| 2 | bus | 40 |
| 2 | train | 47 |
| 3 | car | 35 |
| 3 | bus | 54 |
| 3 | train | 11 |
T
I have tried to make a scatter plot as Legend = Table1[ID], X-axis = Table2[%], Y-axis = Table1[temp]. I have a slicer for the region and transportation mode I have to select. and Each dot is individually colored by the ID.
I'd like to have a scatter plot such as. Please excuse the rudimentary drawing
edit:
For table 1, I forgot to mention there are multiple replicates of the temp taken for each country, region. I can do Legend = Table1[region], X-axis = Table2[%], Y-axis = Table1[temp] and that works for above. However it only works if I have a slicer with one replicate chosen. For each country, region pair, I want the average of all the replicates. Maybe a measure somehow?
