Hello, my friends!
I am using appsheet for keeping record of my cattle.
And in this year I sought that every cow calves from 11 month after last calving.
How can I prepare data model for forecast next calving ?
I have two tables. Table cows - there all records about cows. ID, Birthdate gender and so on.
Second tables named Calves where I am use for linking cow with her calves. There just 4 colunns. ID, ID of the cow , ID of the calf and date when link is created.
Next calving forecast I use last calve birthdate.
For example,
cow #26 calved 2021-01-10. Next calving date will be from 2021-10-20 and "2021-10-27
I need just add for last calving date 283 and 283+7 for end calving.
How can I make predict model for those data table ?