Calculated Field: Candidate NPS

To build the NPS Bucket calculated field, we'll go to admin calculated fields and we'll create a new calculated field based on the candidate experience object.

Next we'll click new and we'll title this.

NPS Bucket.

Next we'll add our first bucket.

In this case we'll call it Promoters and we'll give some context that these will only be submissions that are 9 through 10.

Next we'll add our fields to match and in this case we're looking for the candidate submitted nps.

Let's go ahead and do a search for it.

Next, we want this to be is greater than or equal to nine, which means any nine or ten responses will be included.

Let's add a new bucket in this case for passives that submit in a 7 through 8 range.

This case we want this to be is greater than or equal to seven.

We don't need to put in eight because Ashby is going to evaluate each survey response.

In other words, first it'll check for promoters.

Is the response greater to or equal to 9?

If not, let's move on to, the next criteria.

Is the survey response greater than or equal to 7 If the response is not a 7 or an 8, Ashby will move on to the next evaluation.

In this case, we'll call this Detractors for anyone that submits between a zero or a six.

And lastly, we can rename our other bucket into no survey response since they'll have no score associated if they didn't submit a response.

There we have it.

We've completed our NPS bucket.

Since we have the behavior set to take the first that matches, Ashby will first take a look at the server response.

If it's nine or greater, it will bucket the candidate and promoters.

If not, it will move on to passives and check to see if the response is a 7 or an 8.

If it's neither of those, it will move on to detractors, so on and so forth.

We can now click Save and build reports.