Selection Functions

Description:

A group of functions that return specific data based off rank, position or order.
  • min
  • max
  • first
  • last
  • least
  • greatest
  • if
Syntax:

min(_)     <returns the minimal data record of the selected data set>

max(_)      <returns the maximal data record of the data set>

first(_)       <returns the first data record in the data set>

last(_)     <returns last data record of the data set>

least(_)     <returns the least value (s) of the data set, not limit to one value>

greatest(_)     <returns the maximal value (s) of the data set, not limit to one value>

if(_)     <returns conditional data based of the if statement parameters>

Syntax Example using power:

min(power)     <returns single minimum power record for selected time range>

max(power)      <returns single maximal power record for selected time range>

first(power)       <returns first power record for selected data>

last(power)     <returns last power record for selected data>

least(power,5)     <returns the least five power record for selected data>

greatest(power,5)     <returns the greatest five power record for selected data>

if(power>200(power)     <returns a all power data above 200 watts>

Additional Syntax:

coming soon

Common examples: