Hi All,

I am trying to put together a cycle time report for our TA group.
We want and .XLSX report showing the average time by requisition that it takes to reach each phase in the hiring process.

This is where I am with the data pull:

Req number Candidate Status Days to Status
Requisition 1 Bob Interview 5
Requisition 1 Bob Offer Extend 8
Requisition 1 Bob Offer Accept 10
Requisition 1 Sally Interview 6
Requisition 1 Sally Offer Extend 12
Requisition 1 Jennifer Interview 3
Requisition 2 Gary Interview 1
Requisition 2 Gary Offer Extend 2
Requisition 2 Gary Offer Accept 3
Requisition 2 Cayla Interview 5

I am trying to get an output to look like this:

Req Avg to interview Avg to Extend Avg to Accept
Requisition 1 4.6 10 10
Requisition 2 3 2 3

We have several thousand requisition/candidate combinations in the system.
Any direction or suggested topics to read on would be appreciated.

Best,

-Chad

WebFOCUS 8.09

This message has been edited. Last edited by: FP Mod Chuck,

Chad,

Use the across verb.

 
TABLE FILE [YOUR_TABLE]
[PRINT/SUM] DAYS_TO_STATUS
BY REQ_NBR
BY CANDIDATE
ACROSS STATUS
ON TABLE PCHOLD FORMAT XLSX
END 

Refining Eric's suggestion...

define file reqs
 days/d5.1 missing on = Days_to_status
end
table file reqs
sum ave.days as ''
by Req
across Status as 'avg days to:'
columns 'Interview'
    and 'Offer Extend'
    and 'Offer Accept'
end

Redefine days with D5.1 format, to show one decimal place in Average values.
MISSING to avoid "average" of zero days if status never reached.
COLUMNS to control the listed values and their order

Further thoughts on the requirement.

The raw data are cumulative days, from the "drop of the hat" until each successive status is reached (if and when).

That can result in oddities. For example, Req. 2's average days from start till an offer is extended (2) is shorter than its average days till interview held (3). (The first is the average over two candidates, the latter over just one)

You might instead want to consider presenting the average of days from the previous status, rather than cumulative days from start of the process.