Pivot

Use the pivot command to reshape query results by rotating row values into columns for cross-tabulation.

Usage: <field> | pivot <field>

Description: Splits the data using the unique values of a given column and analyzes the distributions of the other columns for each one of these values.

Example: alerts | pivot protocol

Figure 1. Query result: alerts | pivot protocol

Vantage IQ query result showing alert data pivoted by protocol column values

Example: assets | pivot type

Figure 2. Query result: assets | pivot type

Vantage IQ query result showing asset data pivoted by type column values