Forum Discussion

BenjaminBoothBW's avatar
BenjaminBoothBW
Frequent Visitor
2 years ago

Visualizing hierarchical data

Hello. I have some problems visualizing data in a hierarchical format. I have tried to show the data in the tables below. Process Hierarchies Process Name Level 0 Level 1 Level 2 Level 3 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BenjaminBoothBW 

 

In my tests, I do not have the same problem as you are experiencing.

 

But I found another problem, the value of "Sub_process" in this Matrix does not correspond to the value in the "Process Runs" table.

 

My suggestion:

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • BenjaminBoothBW's avatar
    BenjaminBoothBW
    Frequent Visitor
    2 years ago

    Hello Yulia, thanks for your reply. 

    I have edited sub-process to sub-subprocess in the example data. 

    In the report you posted, I still see the same problem that I was describing. For example, I want Sub_process to show the average of (1+1)/2 = 1 and not including its children as it is currently doing: (1+1+4+4)/4 = 2.5.

    I want the NULL row below sub_process to be the result of sub_process if that makes sense? (See screenshot)