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:

../_images/split-by-agent-example.png

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:

../_images/split-by-multiple-fields.png

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

Published: 16/03/2017

Last updated: 16/03/2017