Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am using D3Dynamic Tree Layout Extension ,I have created hierarchy based on Designation.I want to show Count of employees in each level based on Designation.
Please find the attached file.
Any Suggestions would be greatly appreciated.
Regards,
P.Divya
May be you can try ?
In a Bar chart
Dimension: Designation or Empname (Which describes the designation)
Expr: Count(EmpID)
hi
Are expecting something like this in chart ?
Hi ,
Thanks for quick response.I am expecting in D3Dynamic Tree Extension not in chart.
Regards,
P.Divya
Hello Divya,
Can you post us expected output and in which tab you are referring to ?
Thanks,
V.
Hi,
I've tried various formula in the standard data but obviously the extension will only display the data for that point.
I think you somehow need to calculate the number of employees that the manager has and load this as a field, which you can then use this in the 'measure' column.
Shouldn't be that tricky to do
see this:
Something sort of like this, but currently this will only give you direct reports, not a full count of the employees underneath, sorry its monday and my brain isn't fully up to speed yet
Ok this is a really dirty example, but you should be able to improve it for your needs!
Hi ,
Thanks to everyone for quick response.I want to show count of employees in each level based on designation .
Please find the attached file.I am getting same count in TL level .I want to show count of TLs to the respective Asst Manager.
Thanks & Regards,
P.Divya