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:
derive type:single value:WEEKDAY(Date) as:'DayOfWeek'Values greater than 5 in
DayOfWeekare weekend dates. You can use the following to identify if anyone reached this highwater marker during the workweek (non-weekend):
pivot value:ANYIF(Sales, (Sales > 80 && DayOfWeek < 6)) group:EmployeeId,Date limit:1Before adding the step to the recipe, you take note of the individuals who reached this mark in the
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:
pivot value:LISTIF(Sales, 1000, (DayOfWeek < 6)) group:EmployeeId,Date limit:1To clean up, you might select and replace the following values in the listif_Sales column with empty strings:
[" "] 
This page has no comments.