Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Average Time to Status
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Average Time to Status
 Login/Join
 
Member
posted
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,
 
Posts: 4 | Registered: April 28, 2015Reply With QuoteReport This Post
Master
posted Hide Post
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 


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Average Time to Status

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.