Dynamic Group Sampling Conditions

This article explains Group Sampling Conditions for setting dynamic groups. Conditions based on user information such as login names and department membership can be set for dynamic grouping by using the following specific formatting:

key+single-byte space+operator+single-byte space+("key value")

Example 1: Sampling users whose department code is "sales". 

organization in ("sales")

Example 2: Sampling users whose job title code is manager or chief:

title in ("manager", "chief")

Example 3: Sampling users who satisfy all of the following conditions:

  • Departments with code "sales", or affiliated departments.
  • Users whose job title code is manager.

organization <= "sales" or title in ("manager")

Example 4: Sampling users who satisfy all of the following conditions:

  • Users belonging to department with code "sales", or users whose login name is "Natalie".
  • Users whose job title code is manager.

(organization in ("sales") or user in ("Natalie")) and title in "manager"

Notes:

  • To enter multiple key values, separate them with a comma ",".
  • Combine multiple conditions using the operators "and" and "or".
  • If your calculation involves several steps, you must enclose the formulas that takes precedence in parentheses "( )".

Sampling conditions can also be set in the following combinations:

Key Operator Key values Sampled Users
user in (login name, login name, ...) Any users with one of the specified login names
not in (login name, login name, ...) Any users without one of the specified login names
organization in (department code, department code, ..., department code) Members of any of the specified departments
not in (department code, department code,  ..., department code) Non-members of any of the specified departments
< department code Members of affiliated departments to the specified department
<= department code Members of affiliated departments to the specified department and the specified department itself
group in (group code, group code, ..., group code) Members of any of the specified groups
not in (group code, group code, ..., group code) Non-members of the specified groups
title in (job code, job code, ... , job code) Users with any of the specified job titles
not in (job code, job code, ... , job code) Users without any of the specified job titles
employeeNumber in (employee ID, employee ID, ... , employee ID) Any users with one of the specified employee ID
not in (employee ID, employee ID, ... , employee ID) Any users without one of the specified employee
birth date = birthday Users whose birthday is the specified date
< birthday Users whose birthday is before the specified date
<= birthday Users whose birthday is on or before the specified date
> birthday Users whose birthday is after the specified date
>= birthday Users whose birthday is on or after the specified date
joinDate = hire date Users whose hire date is the specified date
< hire date Users whose hire date is before the specified date
<= hire date Users whose hire date is on or before the specified date
> hire date Users whose hire date is after the specified date.
>= hire date Users whose hire date is on or after the specified date
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.