This section provides simple examples for how to use the
LISTIF functions. These functions include the following:
ANYIF- Identifies a single value from a group that meets a specific condition. See ANYIF Function.
LISTAIF- Lists all values within a group that meet a specified condition. See LISTIF Function.
The following data identifies sales figures by salespeople for a week:
In this example, you are interested in the high performers. A good day in sales is one in which an individual sells more than 80 units. First, you want to identify the day of week:
Values greater than 5 in
derive value:WEEKDAY(Date) as:'DayOfWeek'
DayOfWeekare weekend dates. You can use the following to identify if anyone reached this highwater marker during the workweek (non-weekend):
Before adding the step to the recipe, you take note of the individuals who reached this mark in the
aggregate value:ANYIF(Sales, (Sales > 80 && DayOfWeek < 6)) group:EmployeeId,Date
anyif_Salescolumn for special recognition.
Now, you want to find out sales for individuals during the week. You can use the following to filter the data to show only for weekdays:
To clean up, you might select and replace the following values in the listif_Sales column with empty strings:
aggregate value:LISTIF(Sales, 1000, (DayOfWeek < 6)) group:EmployeeId,Date
[" "]