How to merge Direct database request Analysis and analysis which is developed by subject area

Summary

i need to combine the columns of direct database request analysis with other analysis

Content

My requirement is to count the employees with status of the goal. so i created analysis with Workforce goals-Goals status real time.But now i am facing a challenge that i need to restrict persons count based on the custom HR Representatives Like HR,BU_HR,HR Spoc like.But here there is no folder or subject area for the Representatives so i created Custom analysis with Direct database request having person and HR Representatives details.Now I need to combine the columns of direct database request with goals analysis.So then after that i can make a filter on the HR Representatives.