---
availability: IDEA
description: A plugin that allows employees and managers query any Workday custom
  RaaS (Report-as-a-Service) report in their purview.
name: Look Up Data from a Custom RaaS Report
purple_chat_link: https://marketplace.moveworks.com/purple-chat?conversation=%7B%22messages%22%3A%5B%7B%22role%22%3A%22user%22%2C%22parts%22%3A%5B%7B%22richText%22%3A%22Can+you+show+me+the+turnover+rate+for+the+Marketing+department+this+quarter%3F%22%7D%5D%7D%2C%7B%22role%22%3A%22assistant%22%2C%22parts%22%3A%5B%7B%22reasoningSteps%22%3A%5B%7B%22status%22%3A%22success%22%2C%22richText%22%3A%22Identified+department%3A+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3EMarketing%3C%2Fb%3E+and+time+period%3A+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3ECurrent+Quarter%3C%2Fb%3E.%22%7D%5D%7D%2C%7B%22richText%22%3A%22To+calculate+the+turnover+rate+accurately%2C+do+you+want+to+include+both+voluntary+and+involuntary+terminations+in+the+calculation%3F%22%7D%5D%7D%2C%7B%22role%22%3A%22user%22%2C%22parts%22%3A%5B%7B%22richText%22%3A%22Yes%2C+please+include+both+voluntary+and+involuntary+terminations+for+the+current+quarter.%22%7D%5D%7D%2C%7B%22role%22%3A%22assistant%22%2C%22parts%22%3A%5B%7B%22reasoningSteps%22%3A%5B%7B%22status%22%3A%22success%22%2C%22richText%22%3A%22Confirmed+time+period%3A+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3ECurrent+Quarter%3C%2Fb%3E+and+included+both+voluntary+and+involuntary+terminations.%22%7D%5D%7D%2C%7B%22reasoningSteps%22%3A%5B%7B%22status%22%3A%22success%22%2C%22richText%22%3A%22Retrieved+turnover+data+for+the+Marketing+department.%22%7D%5D%7D%2C%7B%22apiBlock%22%3A%7B%22code%22%3A%22%23+Sample+RaaS+data+after+fetching%5Cnraas_data+%3D+%7B%5Cn++++%5C%22employees_at_start_of_quarter%5C%22%3A+100%2C%5Cn++++%5C%22employees_at_end_of_quarter%5C%22%3A+95%2C%5Cn++++%5C%22voluntary_terminations%5C%22%3A+3%2C%5Cn++++%5C%22involuntary_terminations%5C%22%3A+2%5Cn%7D%5Cn%5Cnstart_headcount+%3D+raas_data%5B%5C%22employees_at_start_of_quarter%5C%22%5D%5Cnend_headcount+%3D+raas_data%5B%5C%22employees_at_end_of_quarter%5C%22%5D%5Cnterminations+%3D+raas_data%5B%5C%22voluntary_terminations%5C%22%5D+%2B+raas_data%5B%5C%22involuntary_terminations%5C%22%5D%5Cn%5Cn%23+Calculate+average+headcount+for+the+period%5Cnaverage_headcount+%3D+%28start_headcount+%2B+end_headcount%29+%2F+2%5Cn%5Cn%23+Calculate+turnover+rate%5Cnturnover_rate+%3D+%28terminations+%2F+average_headcount%29+*+100%22%2C%22connectorName%22%3A%22python-interpreter%22%2C%22title%22%3A%22Execute+Python+script%22%7D%7D%2C%7B%22richText%22%3A%22The+total+turnover+rate+for+the+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3EMarketing%3C%2Fb%3E+department+in+the+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3Ecurrent+quarter%3C%2Fb%3E+is+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3E5.2%25%3C%2Fb%3E.%22%7D%2C%7B%22citations%22%3A%5B%7B%22connectorName%22%3A%22workday%22%2C%22citationTitle%22%3A%22Employee+Turnover+Analysis+Q3+FY24%22%7D%5D%7D%2C%7B%22richText%22%3A%22Would+you+like+a+breakdown+of+voluntary+vs.+involuntary+terminations%2C+or+details+on+the+employees+who+departed%3F%22%7D%5D%7D%2C%7B%22role%22%3A%22user%22%2C%22parts%22%3A%5B%7B%22richText%22%3A%22Please+give+me+the+breakdown+of+voluntary+vs.+involuntary+terminations.%22%7D%5D%7D%2C%7B%22role%22%3A%22assistant%22%2C%22parts%22%3A%5B%7B%22reasoningSteps%22%3A%5B%7B%22status%22%3A%22success%22%2C%22richText%22%3A%22Filtering+turnover+data+to+show+breakdown.%22%7D%5D%7D%2C%7B%22apiBlock%22%3A%7B%22code%22%3A%22%23+Using+previously+fetched+raas_data+and+calculated+average_headcount%5Cn%5Cnvoluntary_terminations+%3D+raas_data%5B%5C%22voluntary_terminations%5C%22%5D%5Cninvoluntary_terminations+%3D+raas_data%5B%5C%22involuntary_terminations%5C%22%5D%5Cn%5Cn%23+Calculate+voluntary+and+involuntary+turnover+rates%5Cnvoluntary_turnover_rate+%3D+%28voluntary_terminations+%2F+average_headcount%29+*+100%5Cninvoluntary_turnover_rate+%3D+%28involuntary_terminations+%2F+average_headcount%29+*+100%22%2C%22connectorName%22%3A%22python-interpreter%22%2C%22title%22%3A%22Execute+Python+script+for+breakdown%22%7D%7D%2C%7B%22richText%22%3A%22For+the+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3EMarketing%3C%2Fb%3E+department+in+the+%3Cb+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3Ecurrent+quarter%3C%2Fb%3E%3A%5Cn%3Cul+xmlns%3D%5C%22http%3A%2F%2Fwww.w3.org%2F1999%2Fxhtml%5C%22%3E%5Cn++%3Cli%3E%3Cb%3EVoluntary+Turnover+Rate%3A%3C%2Fb%3E+3.8%25%3C%2Fli%3E%5Cn++%3Cli%3E%3Cb%3EInvoluntary+Turnover+Rate%3A%3C%2Fb%3E+1.4%25%3C%2Fli%3E%5Cn%3C%2Ful%3E%5CnThis+data+is+from+the+%5C%22Employee+Turnover+Analysis%5C%22+report.%22%7D%2C%7B%22citations%22%3A%5B%7B%22connectorName%22%3A%22workday%22%2C%22citationTitle%22%3A%22Employee+Turnover+Analysis+Q3+FY24%22%7D%5D%7D%2C%7B%22richText%22%3A%22Is+there+anything+else+you%27d+like+to+know+about+this+report%2C+or+perhaps+view+the+turnover+rate+for+a+different+department+or+time+period%3F%22%7D%5D%7D%5D%7D
solution_tags:
- HR - Other
systems:
- workday
---