Forum Discussion

k_rahul_g's avatar
k_rahul_g
Frequent Visitor
2 years ago

Multi level parent child hierarchy summarization

In a hierarchical table "BaseData" , I have to summarise an attribute "timespent" for all LEVELS of child work item. the problem is that the parent (where it need to be summarize) could also be a chi...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

A child cannot have two parents in a hierarchy  (as opposed to IRL) so ignoring the parent entries for 23156 and 13329. Next we need to fill the gaps for childless parents.  Then you can use the PATH functions for your rollups.

 

I'll leave the next step to you.

k_rahul_g's avatar
k_rahul_g
Frequent Visitor
2 years ago

 

The table would always have a childless parents. As there would  be node levels. This can not be eliminated. I tried using th path function and it gives erros that  every workitem (i.e. Parent) should also appear as the child in the table.   

My data would not have this established as there would be workitems that are in analysis and have not been divided into further tasks or stories.  

Hence looking for another work arond. 

 

and while giving sample data i  made that mistake of multiple parents to a child. This is not the scenario in actual data. A child would have 1 parent only.  but a parent would have multiple levels of children.