I am trying to make an animation with the temporal controller of the locations of animals on specific days and would like to display the proportion in each location. The data are in a text-delimited file and organized similar to this example
Barn | Horses observed | Color | Date checked |
---|---|---|---|
A | 1 | Pinto | 2021-12-03 |
A | 2 | Black | 2021-12-03 |
C | 1 | Pinto | 2021-07-22 |
C | 0 | NULL | 2021-04-16 |
C | 2 | Pinto | 2021-12-03 |
B | 2 | Black | 2021-07-22 |
With each barn also corresponding to its gps coordinates. This is the format we used for entry and R. I understand it's not the best for QGIS, but I'm not sure how to reformat it without losing the date column necessary for temporal control.
I made rule-based groupings by making size classes for each color. These can go into point cluster/displacement, but it ends up looking rather... Messy.
Ideally I'd like something like barn A shows a 2:1 pie chart for the colors on 2021-12-03 which is scaled by the total number of horses at the barn that day (3) so it looks larger than barn C which only has two pinto.
I have an approximate idea for what I could do and seek detailed instructions.
How can I "grab" the number observed for each color when selecting the pie chart data and set the size scale to be the total for each barn?
There's no add ranges option when adding diagrams to properties that I can see
sum("Horses observed", group_by:= "Barn", filter:= "Color"='Pinto')
on longform data in the diagram editor retains the use of a single variable but shows up empty on the map.