The Subscribe statement is used for submitting real-time queries, which are queries that are evaluated as the data is streamed in. As a result, the queries can only be applied to Events, Activities, and Snapshots, and only to the “raw” fields - those included in the TNT4J tracking item message.
jKQL> Subscribe to Number Of Event group by Severity output every 5 seconds show as barchart
jKQL> Subscribe to Number Of Event group by Severity output every 5 seconds ORDER BY severity show as piechart
jKQL> Subscribe to number of events where eventname contains 'Order' group by eventname, severity order by severity output every 2 seconds show as colchart