Custom Formulas
Discussion List
-
How do I add Total Submissions field to Hired Candidates by Requistion report?Summary I have a request to add Total submissions for each requisition that has a hired candidate listed.Content The OBI Analysis currently has a row for each candidate … -
Reporting Counts: # of Times a Req has been Posted/UnpostedSummary Need to determine a formula to count the distinct times a req has been posted and unposted during the duration of the req life cycle.Content I have developed a f…Jennifer Tanous-44292 25 views 2 comments 0 points Most recent by Jennifer Tanous-44292 Taleo Enterprise -
OBI - Latest Req Transaction DateSummary OBI - Latest Req Transaction Date formulaContent I have a report in OBI. The Requisition history transaction dates can pull MANY rows. What I'm looking to do is …
-
Percent Formula as Compared to Seven Days AgoSummary Need Column to Compare Last Week to This WeekContent Hello, I need to add in a % Change Calculation for each of my measures into a pivot table.. See the attached… -
YTD Evaluate Code for Dashboard PromptSummary Dashboard Prompt YTD defaultsContent Hi, I am working on a Dashboard prompt to default to YTD to filter all results on the dashboard. I have used a previously cr… -
Requisition Approval Cycle Time - Removing the "Saved as Open" event from calculationSummary Requisition Approval Cycle Time - Removing the "Saved as Open" event from calculationContent Hello - We're attempting to calculate our requisition approval cycle… -
Saving custom formulas as reusuable fields in OBI?Content We use a bin formula across many of our dashboards that we update frequently. It's arduous, because we have to update the formula in every analyses. Is there a w… -
Report of Shortest time to the next stepSummary Need to design a report that shows the shortest time between stepsContent We are hoping to design a report that would allow us to see how quickly we had a candid…
-
Percentage CalculationSummary Trying to write a formula to get me a percentage calculationContent The percentages I am trying to accomplish are two columns below: Historical Step 2 #Submissio…Klayna Guzman-35166 59 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
Pivot Table calculation issueSummary Calculation column in pivot table not providing correct answersContent I have a calculation for the fill rate based upon hired vs target. This is working fine in… -
Need a report to calculate the sourcing TAT (Turn Around Time)Summary Need a report to calculate the sourcing TAT (Turn Around Time)Content Dear Experts, Need your help with a report to calculate the sourcing TAT, here is a the dat… -
OBI Question – How to create a substring or trim to retain the last four digitsSummary OBI Question – How to create a substring or trim to retain the last four digits of a department numberContent We have the need to only retain the last four chara…
-
Aged ReqsContent Plan is to count the no of aged reqs over 40days and then remove any req that has the following submision statuses Hire/Accepted,Awaiting.... I did this but it i…
-
Report on Taleo On-boarding Transition events along with datesSummary Report on Taleo On-boarding Transition events along with datesContent Hi, I would like to create a Taleo OBI report with Tasks name, Step names performed in On-b…
-
Help needed with Count FormulaSummary Would like to count more then one CSW Step in the same columnContent Can anyone help me with this formula? currently it's counting only Step "Submitted" however … -
How to use Action Link to navigate directly to Taleo Requisition No/Candidate IdSummary How to get the URL linkContent Hello Everyone, I do not know what I am doing wrong but I need your assistance in how to link my records directly from OBI to the … -
Taleo report to extract multiple counts of candidates in different steps and statusSummary Taleo report to extract multiple counts of candidates in different steps and statusContent Hi, I am trying to get a report on Taleo recruit OBI to obtain the num…
-
How to drill down to show spec recordsContent An example is a graph of age reqs by org level structures. How do I make my action link work in a way that when one clicks on a particular org level 9 (HR) on th…
-
OBI formula for current Impact of LossSummary OBI formula for current Impact of LossContent The current value of the standard Employee Metric Impact of Loss is not reportable in OBI. We need a formula that w…
-
Count needed for all identified Veterans and identified persons with DisabilitiesSummary I need help getting a count of all the different Veterans that have applied as well as a count of all identified persons with DisabilitiesContent Hi Group! I nee…
-
Hard-coded URL to candidate profileSummary Can you include a hard-coded URL in an OBIEE report?Content Hello, I have a report in Business Objects that includes a hard-coded URL to the candidate's profile.… -
Requisition Activity HistorySummary Help with drill down in Requisition Activity History reportContent I am wanting to use a piece of one of the standard dashboard reports available that shows the … -
Requisition Primary Location Zip CodeSummary Looking to only show Primary location zip codeContent Hello, I am looking to show the primary location zip code in an OBI report. I noticed under Requisition Pri…
-
Application Historical Tracking Date and corresponding Application Historical CSW StepSummary Application Historical Tracking Date and corresponding Application Historical CSW StepContent This is an easy one but my brain is fried with the upcoming holiday… -
Need to display which candidate filled the last open position of filled requisitionsSummary We are not able to display which candidate has filled the last open position of filled requisitionsContent Hi, We have created below custom formula to display th…
-
Subtract 3 hours from a dateSummary Subtract 3 hours from a dateContent Hi All, I'm trying to subtract 3 hours from a date and cannot get the formula to work. Formula in BO =RelativeDate([Job Offer… -
Create a variable to count offer accepts where start date is > current dateContent Hello, I am creating a table that counts by location the various stages of the candidate life cycle. One of those counts is on offer accepts where the start date…
-
Report to show all candidates at least at offer - draft PLUS requisition details of candidate countsSummary Report to show all candidates at least at offer - draft PLUS requisition details of candidate counts at selected step/statusContent I am trying to recreate a rep…Lucy Eggleston-44674 25 views 1 comment 0 points Most recent by Jennifer Tanous-44292 Taleo Enterprise
-
Compliance reportSummary Trying to filter report to show personnel areaContent Creating a compliance report from BO to OBI that is using a subquery. Need to use the Req Identifier to wri…
-
First Req. History Transaction date (when posted externallly)Content MIN(CASE WHEN "Requisition Posting"."Posting Source" = 'Career Section - EXTERNAL' THEN EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER,"Requisition Tracking History"."Re…