Skip to main content

Create a query for the average time the jobs are open for on the ATS

How would I find out the average time our jobs are open for on the ATS via a query.

J
Written by Joshua Shooter
Updated over a month ago

As an admin, to build a report on ATS, follow the steps below:

  1. Click Access Button image then click HR Admin.

  2. Click Queries then click the plus icon.

  3. Select Vacancy.

  4. In the next three columns, select the items to include in the report. In order for this query to pull out the data you wish for, you will need to select at least:

    • Vacancy.

    • Status.

    • Date Created.

    • Closing Date.

    • Then you can apply any filters you find suitable.

Then you can apply any filters you find suitable.

To export this in an Excel file, follow the steps below:

  1. Select your query then select Export to on the top right corner.

  2. Click Export to Excel.

  3. From there you can apply any other filters or formulas you might find useful.

Did this answer your question?