transformations:filterminmax
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revision | |||
— | transformations:filterminmax [2023/10/05 00:35] (current) – [See also] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== KEEP MIN/ | ||
+ | Category: Transform / Filters\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action keeps (or removes) only rows with values that are the biggest or smallest in a specified column.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Use this action to generate datasets of "top N" or " | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Column|Select the column to filter values on.| | ||
+ | |Keep or remove? | ||
+ | |Biggest or smallest? | ||
+ | |How many (numbers/ | ||
+ | |Inside groups|When checked, the min/max process will operate within groups of values in the column(s) selected (and select the column(s)).| | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | Taking into account ties, the number of rows returned by this action may exceed the " | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example: | ||
+ | |||
+ | **Source table:** | ||
+ | ^ Product ^ Price, USD ^ | ||
+ | |A | 12| | ||
+ | |B | 16| | ||
+ | |C | 14| | ||
+ | |D | 13| | ||
+ | |E | 13| | ||
+ | |F | 9| | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column is " | ||
+ | > " | ||
+ | > Count is " | ||
+ | |||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^ Product ^ Price, USD ^ | ||
+ | |A | 12| | ||
+ | |D | 13| | ||
+ | |E | 13| | ||
+ | |F | 9| | ||
+ | Although the " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/filterminmax.txt · Last modified: 2023/10/05 00:35 by dmitry