Add count of child when Parent and child in same dataset

Question & Answer
1

I have a dataset which contains both parents and child nodes

ID ParentID isparent haschild
1200 null TRUE TRUE
1201 1200 FALSE FALSE

In this example I want to create the “haschild” field or count the no of children for each row. So count the no of times parentID in the data matches the ID of the row

2

Hi @sanji - Welcome to AWS QuickSight community and thanks for posting the question. Is your data source is RDBMS like MySQL or Redshift, if yes, you can create a custom sql and do a self join and extract these fields.

@Ashok @Max - Any advise on this.

Regards - Sanjeeb