Department Hierarchy data in the "Workforce Learning - Learning Records Real Time" subject area

Summary:

we are combining the "Workforce Learning - Learning Records Real Time" and "Workforce Management - Worker Assignment Real Time" subject area's to get the count of "- Hierarchy"."Level 4 Department" based on "Assigned Learning Item Information"."Assigned Learning Item Title"

But Level 4 Department Count is displaying as 0 even though we have data. Please guide in the correct direction

attached the XML code for reference

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):