The optional SPLIT BY clause enables you split the results into separate tables/graphs by providing split field values.

For example, if you wanted to display each agent’s matching tickets for a query in a separate table, you’d use:

SPLIT BY tickets.agent
 copy

and the result would look like this:

with a separate table for each agent.

You can use multiple split fields by providing a comma-separated list of expressions. This will result in separate tables for each combination of of the fields you provide. For example:

SPLIT BY tickets.agent, tickets.department
 copy

produces output like this:

with separate tables for Agent A/Department A, Agent A/Department B, Agent B/Department A, etc.