Currently it is listing each chore log, causing duplicate chores to show.
This may be caused by views aggregation and a reverse entity relationship.
Chore log has a regular date field, no time.
Issue
Date field is not displaying correct value on a views with aggregation max/min
Timestamp fields are working, but date fields are not.
Workarounds
Using date created instead.
Instead of sorting the date field as a view sort, do it as the default table sort.
I found a good trick for this here: https://contrib.drupalarchitect.info/project/drupal-community-contrib/t…
Views Date Format SQL
View Views Date Format SQL on Drupal.orgViews Date Format SQL
Should help with date aggregations in views.
Issue: Using Views Date Format SQL options on custom date fields
Didn't work for aggregating date fields or timestamps.
Resolution
Don't try to aggregate on max chore log date.
Otherwise, aggregation is working to group by chore in pinned - but maybe that is not necessary any more, since we can use the last log date.