xyseries

Convert tabular data into a series (pivot) format, suitable for charting.

Syntax

| xyseries <x-field> <y-field> <data-field>

Examples

-- Pivot status counts by source
| stats count by source, status | xyseries source status count

Notes

• xyseries pivots rows into columns. The x-field becomes the row key, the y-field values become column headers, and the data-field provides the cell values.

See Also

• timechart -- Time-series pivoting
• stats -- Aggregation