Drupal 8, Views: Count how many children have a reference to the parent
1) I have a node "parent"
2) I have 2 nodes "child"
3) Each child has a reference field (filled with a reference to the node "parent")
Now, I'm trying to create a list with the Views module.
First problem: This list is a list of "parent" nodes AND should include a column with the following result: COUNT(child with a reference to the parent).
Second problem: The count result should include only published children.
Example 1 with 2 children published (2 children have a reference to the parent):
Title of parent node | 2
Example 2 with 1 child published (2 children have a reference to the parent):
Title of parent node | 1
Sorry if it's not totally clear, it's hard to explain Thank you