I use the "statistics by category" tool from QGIS to learn what grain yields I got from different combinations of scenarios like:
Soil A + Hybrid A + Planting Date A = Yield n Soil B + Hybrid A + Planting Date A = Yield n2 ... so on and so forth.
Here`s what I do today:
I take the yield data from the combines that come as points and convert to SHP.
The shapefile now have 1 column only (Yield).
Then I use the "Join attributes by location" tool to extract data from other polygon layers that I want to analyse (like Planting maps with Hybrids locations, soil type maps etc) and add those info into my yield shapefile.
Then I run the statistics from this shapefile that has each point with all the atributes that I want to analyse.
It does work but it`s a really time consuming process, specially because my yield shapefile contains millions of points so every step takes several minutes to be processed.
Any Ideas on a more efficient procedure?
Here`s a screenshot of a final product that I have today and that I would be looking for something similar with a different solution.