Syntax
GROUPBYGAP(<number, date>;<number>)
Description
This functions displays values by defined gap sizes from a column. A GROUPBY() function must first be used in order to then find the gaps in arguments of another column in relation to it. When run, the function sorts the numbers or dates in ascending order by group. The results displayed are the data values greater than the user made "max gap" value. These gaps are defined as being from each value to the next subsequent value.
...
Info |
---|
If the first parameter is a date:
|
...