How to create a report by Department hierarchy?

LinhN
Tera Contributor

Hi guys, I am stuck in creating a report for Users who belong to a department. Now I don't have any solution for this. Can you suggest any solution? My company doesn't have a license for Performance Analytics

Scenario: I want to create a report for the examination results of the assignee. I want to make a Bar chart and group it by department level. But I got stuck when a department has many layers. Here is the hierarchy 

LinhN_0-1733330101305.png

I want to create a report grouped by Parent department and displaying the expected result: Department B.1 (Bar 1) has 18 users, Department B.2 (Bar 2) has 14 users, and Department B.3 (Bar 3) has 6 users. Now when I group the report by Department, it displays Business Unit as a Bar, I just want to display Parent Department only. Please help me a solution for this? 

 

LinhN_0-1733300643543.png

 

 

4 REPLIES 4

Sanjay191
Tera Sage

Hello @LinhN 
Did you make  report  like this 

Sanjay191_0-1733385166121.png



If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You

 

LinhN
Tera Contributor

Hi, I want to create a bar chart to compare numbers among many departments

LinhN_0-1733385658032.png

 

Hello @LinhN 
Did you try with stack by in report so that it will compare numbers among many departments


If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You

Shruti D
Tera Guru

Hello @LinhN
Select Type as "Bars" to display the report  as a bar chart. Also in Configuration tab add the condition in "Stack by" field as per shown in below snapshot.

Shruti_19_1-1733390230256.png

Shruti_19_2-1733390262701.png

 

 

Shruti_19_3-1733390292831.png

 

 



Please Mark Correct ✔️ if this solves your query and also mark Helpful  👍if you find my response worthy based on the impact.

Regards,
Shruti