Creates a Time Chart using
max() as the aggregate function for the
value field.
logscale
|round(_max,how=floor)
Rounds the implied field from the aggregate
max() using the floor
option to round down the value.
Event Result set.
Summary and Results
Using the floor
parameter to a function always rounds down a number. This is
useful when displaying information in a time chart as all numbers
resolved to their base value which can make the differences
between values easier to distinguish when used on a graph.
Rounding to n Decimal Places
Query
logscale
format("%.2f",field=value)
Introduction
To round a number to a specific number of decimal points, use
format() rather than
round()
Step-by-Step
Starting with the source repository events.
logscale
format("%.2f",field=value)
Rounds the field value
to two decimal places.
Event Result set.
Summary and Results
When using format(), rounding is performed
using standard math rules. The format()
rounds a number to a specific decimal accuracy. To round a number
to the nearest decimal, use round().