The documentation for Pivot has included a "LIMIT" operator for quite some time, yet there is no explanation of what it does or how to use it. I have not yet seen any examples that use it either. Can someone shed some light on this?
Here is the snippet of documentation from the Pivot Knowledgebase page. This is all. There is nothing else mentioned.
Descriptions for limit elements
Limit <limit expression>
Syntax: LIMIT <fieldname> BY <limittype> <number> <stats-function>(<fieldname>)
Description:
Hello rjthibod
Thank you for pointing out this missing information. I've updated the documentation as well. Hope this helps!
Limit limit expression
Syntax: LIMIT fieldname BY limittype number stats-function(fieldname)
Description: Use to limit the number of elements in the pivot. The limittype argument specifies where to place the limit. The valid values are top or bottom. The number argument must be a positive integer. You can use any stats function, such as min, max, avg, and sum.
Example: LIMIT foo BY TOP 10 avg(bar)
Hello rjthibod
Thank you for pointing out this missing information. I've updated the documentation as well. Hope this helps!
Limit limit expression
Syntax: LIMIT fieldname BY limittype number stats-function(fieldname)
Description: Use to limit the number of elements in the pivot. The limittype argument specifies where to place the limit. The valid values are top or bottom. The number argument must be a positive integer. You can use any stats function, such as min, max, avg, and sum.
Example: LIMIT foo BY TOP 10 avg(bar)
Thank you very much.