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().