I am trying to visualise temporal data following this tutorial (but using my own data). I have a standalone table with the data in at different times for each feature, in a similar fashion to below (ie multiple entries for the values for each building at different times).
building | time | count |
---|
library | 22/11/2018 00:20:00 | 1 |
house | 22/11/2018 00:20:00 | 2 |
school | 22/11/2018 00:20:00 | 2 |
library | 22/11/2018 00:40:00 | 3 |
house | 22/11/2018 00:40:00 | 2 |
school | 22/11/2018 00:40:00 | 4 |
library | 22/11/2018 00:60:00 | 3 |
house | 22/11/2018 00:60:00 | 5 |
school | 22/11/2018 00:60:00 | 6 |
The standalone data table has 3,096 rows, showing the values for 43 buildings at 72 different times. The spatial data, to which I am trying to join the table, has 199 buildings (43 of which I have data for in the standalone table).
When I try to join the table to the layer, following the tutorial, the result only keeps the first instance of each building, ie the number of records in the layer's attribute table doesn't increase to include the values for each building at each point in time (as in the tutorial), but instead stays at 199 and only joins the values for the earliest time (thus making it impossible to visualise the data across time). Attached is a screenshot of the settings I have for the join – I've replicated those in the tutorial video but seem to have got a different result.
Where am I going wrong?