Forum Discussion
Visualizing hierarchical data
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.
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)