Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employee's workschedule along with start date. After adding this, there are multiple records that are being returned for an employee with inactive/nonprimary workschedules as well. There is no luck despite trying various formula/analysis filter/dashboard prompts. I have come across similar thread but could not figure out how the result column was built. Link here

Attached is the XML of the analysis. Can someone please guide to achieve this?