Hi @DaveBunn, I wrote the Word Tree Viz and as cool as it is... I don't think it will give you what you need in this case. However, you may be interested in the Treeview Viz. Here's some SPL to cr...
See more...
Hi @DaveBunn, I wrote the Word Tree Viz and as cool as it is... I don't think it will give you what you need in this case. However, you may be interested in the Treeview Viz. Here's some SPL to create a treeview representation of the hierarchy: |makeresults
| eval raw = "Name=\"Dave Bunn \", OrgPosition=\"12345_Dave_Bunn \",Manager=\"1230_Mrs_Bunn\",MiscDetails=\"some text about my job\"@@@
Name=\"Mrs Bunn\",OrgPosition=\"1230_Mrs_Bunn\",Manager=\"10_The_Big_Boss\",MiscDetails=\"some text about Mrs Bunns job\"@@@
Name=\"Big Boss\",OrgPosition=\"10_The_Big_Boss\",Manager=\"0_The_Director\",MiscDetails=\"Manager of HR\""
| makemv raw delim="@@@" | mvexpand raw | rename raw as _raw | fields _raw | extract | fields - _time, _raw
``` Above: Creating the test data ```
| rename OrgPosition as id, Manager as parentid, Name as label
``` This bit is to fix any managers that don't appear in the data - i.e. 0_The_Director```
| appendpipe[|stats count by parentid| eval label=parentid, id=parentid | table label, id]
``` Reverse so the appendpipe appears first for the visualisation```
| reverse
| eval iconDoc="user-circle", iconFolderOpen="users"
| eval color=if(label="Dave Bunn","#DC4E41",null()) And here's what it looks like: Alternatively, you could use the Network Diagram Viz: SPL looks like this: |makeresults
| eval raw = "Name=\"Dave Bunn \", OrgPosition=\"12345_Dave_Bunn \",Manager=\"1230_Mrs_Bunn\",MiscDetails=\"some text about my job\"@@@
Name=\"Mrs Bunn\",OrgPosition=\"1230_Mrs_Bunn\",Manager=\"10_The_Big_Boss\",MiscDetails=\"some text about Mrs Bunns job\"@@@
Name=\"Big Boss\",OrgPosition=\"10_The_Big_Boss\",Manager=\"0_The_Director\",MiscDetails=\"Manager of HR\""
| makemv raw delim="@@@" | mvexpand raw | rename raw as _raw | fields _raw | extract | fields - _time, _raw
``` Above: Creating the test data ```
| appendpipe[| stats count by Manager | eval type="user", nodeText=Manager, from=Manager | table from, nodeText, type]
| appendpipe[| stats count by Name, OrgPosition | eval type="user", from=OrgPosition, nodeText=Name | table from, nodeText, type]
| appendpipe[| stats count by OrgPosition, Manager | eval from=Manager, to=OrgPosition | table from, to]
| eval color=if(nodeText="Dave Bunn","red",null())
| table from, to, nodeText, color, type
| search from=* When choosing a hierarchal view, that gives you this: It will look a bit more impressive when there are more people and roles listed. Hopefully those two visualisations give you something to work from. Cheers, Daniel