Skip to main content

INCLUDE

Written by Tom Williams

Type: Function

Function: INCLUDE

Syntax: INCLUDE(list, value)

Description: Returns true if the list contains the value.

INCLUDE takes a single value. To check several values, use INCLUDE_ANY_OF (any of them) or INCLUDE_ALL_OF (all of them).

It is the same condition as the contains filter of the insight designer (see Using filters). Use it in a custom formula, to count, group or label records on that condition, or as a filter in a query sent through the Keypup API or MCP server.

Sample usage:

  • INCLUDE(label_names, "bug") returns true for the records labelled "bug".

  • INCLUDE(label_names, "bug") ? "Bug" : "Other" as a dimension splits the records between bugs and the rest.

Did this answer your question?