Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to make hierarchy chart. I already have 9 hierarchy levels in my table. But it is not working since I don't have depth as a field and when I am trying to use Hierarchy function, it is taking forever to load the data. What should I do? Is there any way to make hierarchy chart without using the hierarchy function? I already have all the data in my table.
Hi Apurva,
Use this Formula and will get Depth From this.
Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName, '\', DepthNew)
I think u have nodeID,parentID,Nodename,Parent Name
Insert "PathName, '\', Depth" as it is you will get Depth automatically.