This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

"If was ever true" Functionality

Posted on 03-30-2023 07:41 AM
Clarissakate213
New Member
Reply posted on --/--/---- --:-- AM

Hello - 

Our company uses Looker within our Talent Acquisition Platform.  I am wondering if there is a way in Looker to create a custom field or calculation to determine if something was ever true.  

For each candidate we have in our pipeline, we would like to see if they are currently, or were ever, tied to a certain Requision ID number.  I have found a way to see if they are currently tied to that Requisition ID number, but not if they are not still tied to that ID.

Any help is appreciated!  Thank you!

0 1 87
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Shru
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

A table calculation should help to identify those records.

if(yesno_expression, value_if_yes, value_if_no)

  1. Call 2 fields Candidate_id and Requisition_id in your look.
  2. Create a table calculation for ‘if’ condition. Type if and it should prompt the format.
  3. if(Requisition_id is null, yes,no). 
  4. This will create a new field in your look. Give this field a name.
  5. Go to the settings option (gear icon) of the new field and select ‘Hide No’s from visualization’. This should give only those candidates whose Requisition_id is not filled yet.
0 Likes