Time to Fill Reporting in Bullhorn Reporting (Previously Canvas)

Whether it’s for KPI or other business purposes, you may want to see how many days it took your recruiters to move a candidate through your workflow stages. You can use Bullhorn Reporting’ calculate feature to quickly determine that length of time.

Creating the Query

We will begin this report by first creating a query, rather than a list. We are doing this to ensure we have certain data items available which won’t display on our list.

Steps

1. Click on Report, then Queries.
   
2. Under Insertable Objects > Toolbox > double-click Query.
3. Right click Query1, then select Rename Query.
   
4. In the Name pop-up, enter the Value as “Job Information”, then select OK.
5. Double-click Job Information, which is the newly named query.
6. Under Insertable Objects, in the Sources tab, click User Activity Analysis > User.
   
7. Double-click Name to add it to Data Items.
8. Still under Insertable Objects > Sources > User Activity Analysis, click Job Owned > Job.
   
9. Double-click Date Added > Job Title > Job ID to the Data items.
   
10. Still under Insertable Objects > Sources > User Activity Analysis > Job Owned, click Job Submission.
    
11. Double-click Date Added to add it to the Data items.
12. Under Data items, click Date Added1.
13. In Show properties, under Data Item > Name, click DateAdded1.
    
14. Type “Submission Date” and then on the keyboard, press Enter.
15. Still under Insertable Objects > Sources > User Activity Analysis , click User > Client Submission Added > Client Submission > Date Sent.
    
16. In Show properties, under Data Item > Name, click Date Sent.
17. Type “Client Submission Date” and then on the keyboard, click Enter.
18. Still under Insertable Objects > Sources > User Activity Analysis , click Job Owned > Job Interview.
19. Double-click Date Added to add it to the Data items.
20. Under Data items, click Date Added1.
21. In Show properties, under Data Item > Name, click Date Added1.
22. Type “Interview Date Added" and then on the keyboard, click Enter.
23. Still under Insertable Objects > Sources > User Activity Analysis , click Job Owned , click Job Placement.
24. Double-click Date Added to add it to the Data items.
25. Under Data items, click Date Added1.
26. In Show properties, under Data Item > Name, click Date Added1.
27. Type “Placement Date Added" and then on the keyboard, click Enter.
28. Click Report > Page1.
    

Creating the List

Now we’re going to create the list for the report.

Steps

1. Under Insertable Objects, from the Toolbox tab, double-click List.
2. On the Object and query name pop-up, for the Name, type “Time to Fill".
3. For the Query Name, choose Job Information, then click OK.
   
4. Under Insertable Objects, from the Data Items tab, double-click Name and Job Title to move this onto the list.
5. In the table, click Name. Holding down Shift on your keyboard, also select Job Title. With both column headers selected, click Group/Ungroup.
   

Time Calculations

Now we are going to create the following four calculations to get our data:

• Days to Internal Submit
• Days to Client Submit
• Days to Interview
• Days to Placement

Steps

1. Under Insertable Objects, from the Toolbox > Textual, double-click Query calculation.
2. In the Data item expression - Data Item1 pop-up, for the Name, type “Days to Internal Submit”.
3. In the Expression Definition box, type the below expression:
   
   Copy

   (_days_between(minimum([JOB OWNED].[JOB SUBMISSION].[dateAdded] for [JOB ID]), [Date Added] )

4. Click Validate.
5. Fix and errors that come up, then click OK.
   
6. Under Insertable Objects, from the Toolbox > Textual, double-click Query calculation.
7. In the Data item expression - Data Item1 pop-up, for the Name, type “Days to Client Submit”.

8. In the Expression Definition box, type the below expression:
   

   Copy

   (_days_between(minimum([Client Submission Date] for [Job ID]), [Date Added]) - [Days to Internal Submit] )

9. Click Validate.

10. Fix and errors that come up, then click OK.
11. Under Insertable Objects, from the Toolbox > Textual, double-click Query calculation.
12. In the Data item expression - Data Item1 pop-up, for the Name, type “Days to Interview”.

13. In the Expression Definition box, type the below expression:

    Copy

    (_days_between(minimum([Interview Date Added] for [Job ID]), [Date Added]) - [Days to Client Submit] )

14. Click Validate.

15. Fix and errors that come up, then click OK.
16. Under Insertable Objects, from the Toolbox > Textual, double-click Query calculation.
17. In the Data item expression - Data Item1 pop-up, for the Name, type “Days to Placement".

18. In the Expression Definition box, type the below expression:

    Copy

    (_days_between(minimum([Placement Date Added] for [Job ID]), [Date Added]) - [Days to Interview] )

19. Click Validate.
20. Fix and errors that come up, then click OK.

Filtering the List

Finally, we want our report to only show data when a job actually exists for our users. Otherwise, Canvas will print all of our users with blank data due to our use of the User Analysis Package.

Steps

1. Select Filters from the toolbar and choose Edit Filters….
   
2. In the Filter - Job Information pop-up, click Add.

3. In the Create filter pop-up, select Advanced and then click OK.
   

4. In the Expression Definition box, type the below expression:
   

   Copy

   [Job Title] is not missing

5. Click Validate.
6. Fix and errors that come up, then click OK and OK again.
7. You may now Save and Run your report.

You now have a report that tells you how many days it took for a job to move from one workflow step to another. You can further enhance your report by Linking to Bullhorn Records in Bullhorn Reporting (Previously Canvas).