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
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
produces output like this:
with separate tables for Agent A/Department A, Agent A/Department B, Agent B/Department A, etc.