bottom() function sorts a table by columns and keeps only the bottom
bottom() is a selector function.
bottom(n:10, columns: ["_value"])
bottom() drops empty tables.
Number of records to return.
List of columns by which to sort.
Sort precedence is determined by list order (left to right).
Default is piped-forward data (
The following example uses data provided by the
to show how
bottom() transforms data.
Return rows with the two lowest values
import "sampledata" sampledata.int() |> bottom(n:2)
View input and output
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.