This is the formula I have been using to work around this: MAX(CASE WHEN "Requisition Status - Current"."Current Status"="Requisition Status - Historical"."Historical Status" THEN "Requisition Status - Historical"."Req. Historical Status Start Date" END)

You can enter a custom "no results" message in Edit Analysis Properties, screen shot below...

I've never tried a SQL filter to quite that volume but it will handle more than basing it on another analysis. I agree it would be beneficial if there was an easier way to execute this scenario with a larger data set.

Sara, you might be able to get to this using a SQL filter or filtering based on the results of another analysis. Below is an example of a SQL filter where the filter is returning the Candidate ID of any submission that accepted an offer within a timeframe. The WHERE statement can be modified for a broader purpose than just…

Submission sources are available in OBI (screenshot attached), are you trying to easily report on deltas for sources across submissions?

There's not a way that I've ever found. This might be good to post on the Ideas board.

In the title container, click into Edit View and then click into Format Title View (per the screen shot below) and then edit the border accordingly

I have not found a way to copy a value directly out of OBI. What I invariably end up doing is creating a deep link for the value that brings up that record in the application. There is a Taleo specific knowledge document that may serve as a good starting point for you. Create Requisition and Candidate Links in OBI (Doc ID…

If the fields are different types this is the cast function I referenced above:

The applied filter would look like this:

You should be able to set the fields equal to each other without the case statement using the Advanced SQL Filter

For testing purposes, does the analysis work if you remove Legal Employer.Effective End Date (or one of the two other fields suggested: Legal Employer.Effective Start Date or Legal Employer.OrgUnitClassificationId)? Adding CAST to the filter fields may change the behavior but you'll want to test removing those fields first.

Ruth, Within an analysis this can be accomplished by a CASE statement, where 'True' is the behavior if there is a match and 'False' if there is not: CASE WHEN "Workforce Management - Person Real Time"."Person Legislative Information"."Country" = "Legal Employer"."Legislation" THEN 'True' ELSE 'False' END If you are…

I've provided a screenshot of the steps to take below. On the Criteria tab, select Column Properties on the field you want to link from, click the Interaction tab, under Value select Action Links as the Primary Interaction, click add and then select the appropriate action (Navigate to BI Content). From here you'll just…

Paul, There are two ways to approach this, see examples below (where 'step' = your step and 'status' = your status): FILTER("Candidate Counts"."# Submissions" USING (("Submission CSW Status - Historical"."Historical Step Name" = 'step') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'status'))) or…