mode()

Table of Contents

Definition
Examples
Further Reading

Definition

mode() returns the most frequent value of the table column. You can use it with transform commands that support aggregations.

Examples

The following example shows the most frequent values of operation column and groups values by the user column.

%dpl
index=join_json_one earliest=-3y
| spath
| chart mode(operation) by user

example of mode aggregation

Further Reading