I have a shapefile layer with locations of dead birds, their total number is about 180, the locations where they were found are about 70. The shapefile contains the Latin name of each of the birds, as well as the order to which the bird belongs, as well as the X and Y coordinates of the location each of the birds is found. I want to create a pie chart for each of the locations showing the number and order to which the found birds belong.
I am attaching an image of the result I want to achieve:
as well as a sample of the data I have:
I tried the charts in QGIS, but as far as I understand it only works with numeric values. With the "Statistic by Categories" tool, I was able to retrieve the total number of victims for each of the locations, but I can't seem to get a handle on the order they belong to. I don't know if I'm even on the right way with "Statistic by Categories".