SQL
Discussion List
-
Prescreening QuestionsSummary Can you report on prescreening questions?Content I was trying to build an analysis that included the candidate's answers to prescreening questions. I checked the…
-
# of Submission with Different ConditionsSummary Need Help with the design of formulasContent Hi All, Is it possible to create two data fields that calculate two different conditions? I am trying to calculate t…
-
Combine Two CASE WHEN formulasSummary Need HELP with Nested FormulasContent I was looking for ways to combine the following two CASE WHEN formulas and did the calculation based on the filtered data. …
-
Time to ContactSummary Duration in days to the first contactContent Hello, I am trying to calculate the "time to contact". That is, the time from Submission complete to the first statu…
-
Extract Substring (of varying length) within a String (of varying length)Summary How to extract a sub string from within a stringContent Hi There, I have a situation where I have a text string of the format. To be precise it is the Grade Code…Shailendra Singh-73567 52 views 6 comments 0 points Most recent by Casey Prater-63029 Taleo Enterprise
-
Return "final" historical status in stepSummary If a candidate was passed but then rejected in one step, we only want to return the final status of rejected.Content We want to count how many candidates were in…
-
Help with finding how many days Candidates sit in a specific step using Taleo OBISummary I need help with findind how many days Candidates have been sitting in a specific step in TEE, using Taleo OBI Reporting.Content I need help with finding how man…
-
OBI Reporting - Formulas for Time Sensitive ReportingSummary Need help with creating time/date sensitive filtersContent I will be the first to admit that I am not the most savvy when it comes to reporting in OBI. We are st…
-
Counting Candidates in "Pipeline"Summary We would like to count the number of unique candidates in specific steps and statuses.Content Hi! I'm trying to build a report that shows the number of "active" …
-
Return only latest Application Reject/Decline Motive in OBISummary Trying to pull the final reject/decline motive per application in an OBI reportContent We had Application Tracking Reject/Decline motive on a report in Business …
-
Formula Help to Pull All Hires For Previous Month And Agent to Send 1st of Following MonthContent I have a weekly hired report that one user only needs monthly. I can create a monthly version to save but cannot figure out how to pull the data for the previous…
-
How to Calculate Query 1 MINUS Query 2Content Hi All! I suspect this will be real easy for some folks! Would anyone be willing to post instruction or point me in a direction to where I might find out how I w…
-
Most Recent Posting DateSummary Creating a report for time to offer accepted based on posting date, want to pull only most recent posting dateContent I am trying to pull only the most recent po…Sarah Niemeyer-57906 77 views 4 comments 0 points Most recent by Sarah Niemeyer-57906 Taleo Enterprise
-
Consolidating lines in a union report tableContent I have a union report below, in one of the unions I have req data and the last column is SUM(0) In the other union I have all columns with the statement of '' ex…
-
Format UDF Attribute from Plain Text to Date?Summary I have a UDF that is in plain text format but I need it be able to filter on a time period.Content My UDF is Relocation Date. The screenshot shows the current Da…
-
OBI TEE - Exclude Reqs with specific questionSummary Filter still shows reqs with excluded questionContent Need some help finishing this statement it should be simple, I'm just not getting there. I am not figuring …
-
Help with OBI IF formulaSummary Issue: OBI does not have the referrer candidate ID and need help writing SQL formulaContent We are having an issue where OBI does not have an object for the refe…Bethany Strothmann 73 views 3 comments 1 point Most recent by Santosh Tekumalla-14206 Taleo Enterprise
-
What is this statement missingContent The entire report results in an error when I use this statement, does it have something to do with the result format? The UDF is a date as well. CASE WHEN MAX("S…
-
Formula for # of candidates in Inteview stepSummary We currently have a formula to count the number of candidates in the interview step (not including those rejected) but we have added a new status and need to upd…
-
Offer Accept DateContent This issue has been causing me a lot of headaches since we first started using Taleo. I need an easy to show the first time an offer was accepted. Our recruiters…
-
What am I doing wrong with this statement?Content MONTH(MIN("Submission Dates"."Offer Accepted Date" BY "Submission General Info"."Submission Identifier")) Results in error, if I just want the Min date it works …
-
OBIEE Reports Analysis with Multiple ValuesSummary How to combine and/or remove multiple valuesContent Hello, I am building an analysis and I have multiple values for a candidate. I would like to combine them to …
-
Tracking Submissions (Did Not Receive Rejection Letter)Summary Tracking Submissions (Did Not Receive Rejection Letter)Content Hello, I'm in the process of creating a formula that will tracking how many submissions did not re…
-
Fast Formula HelpSummary Formula Help- Time Stamp FormulaContent Hi All, This formula works but provides all "0" results. I think I am probably missing or need a different combination of…
-
OBIEE: Performance Management Universe - Goal ReportContent Hi! I'm wondering what other clients have done in the space of Goal Plan reporting. After doing some research, I've learned that the performance management table…Natalie Andrek-27262 59 views 12 comments 1 point Most recent by Michele Bizjak-Yenulonis Taleo Enterprise
-
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 …
-
Remove reverted candidates from showing in results?Content Hello! I have some reports that show # of candidates historically that made it to a step/status but I am hoping to remove reverted candidates that are showing up…
-
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…