Hi @aymenrafik welcome to the farmOS forum!
The first step is to establish your “standard convention” for recording the data you will need to compute those reports. Are you logging those records already, or do you need help thinking though the best way to do it?
Once you have the data, there are a few options:
- Export to CSV and analyze in a spreadsheet (as you described) - This is the easiest because it doesn’t require any programming.
- Experiment with JupyterLite to create a custom report in Python/JavaScript (see Share your JupyterLite Examples)
- Build a custom farmOS module to add a custom report directly to the farmOS UI. This requires knowledge of Drupal module development (PHP), but provides the ultimate experience because you can view your reports directly in farmOS.
Since farmOS v2 was just released (on Jan 1) there aren’t any “built-in” reports yet - but I think it’s just a matter of time (and contributors!) before we see more reporting modules available to install.
For example, the “Animal Weight Report” module that was included with farmOS v1 is currently in development here: farmOS Animal Weight | Drupal.org