How to create a report by Department hierarchy?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 08:40 AM
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
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 11:52 PM
Hello @LinhN
Did you make report like this
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2024 12:02 AM
Hi, I want to create a bar chart to compare numbers among many departments
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2024 12:39 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2024 01:15 AM - edited 12-05-2024 01:18 AM
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.
Please Mark Correct ✔️ if this solves your query and also mark Helpful 👍if you find my response worthy based on the impact.
Regards,
Shruti