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
View on Drupal.org #3151654Date field is not displaying correct value on a views with aggregation max/min Status: Needs work
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: View on GitLab #2978329Using Views Date Format SQL options on custom date fields Status: Needs review
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.