Often you may be asked to report on  how many jobs have been posted but it is important that you apply some filters to your report to avoid giving incorrect data.

  • You may post 1 job to multiple sites i.e. internal and redeployment.  This will count as two job postings
  • You may have posted, un-posted then re-posted a job.  Again, this will count as two job postings.

To help avoid this then you may wish to get confirmation of which site the data is required for.  You can then filter the report to show the sourcing name equal to the relevant source.  

To avoid having un-posted/cancelled postings appearing then you can apply a filter to show posting status not equal to unposted.  This will again refine your criteria in the first instance and avoid needing to manipulate excel.