transformations:filterminmax
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:filterminmax [2018/08/15 08:44] – created dmitry | transformations:filterminmax [2023/10/05 00:35] (current) – [See also] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Keep min/max ===== | + | {{ transformations: |
+ | ====== KEEP MIN/MAX====== | ||
+ | Category: Transform / Filters\\ | ||
- | This action keeps (removes) only rows with values that are the biggest | + | \\ |
+ | =====Description===== | ||
+ | This action keeps (or removes) only rows with values that are the biggest | ||
- | **Example** | + | \\ |
+ | =====Use cases===== | ||
+ | Use this action to generate datasets of "top N" or " | ||
- | Table: Before | + | \\ |
+ | =====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 ^ | ^ Product ^ Price, USD ^ | ||
|A | 12| | |A | 12| | ||
Line 13: | Line 38: | ||
|E | 13| | |E | 13| | ||
|F | 9| | |F | 9| | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column is " | ||
+ | > " | ||
+ | > Count is " | ||
- | Goal: obtain products with the lowest 3 prices. | + | \\ |
- | + | **Result table:** | |
- | Table: After | + | |
^ Product ^ Price, USD ^ | ^ Product ^ Price, USD ^ | ||
|A | 12| | |A | 12| | ||
Line 22: | Line 51: | ||
|E | 13| | |E | 13| | ||
|F | 9| | |F | 9| | ||
+ | Although the " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/filterminmax.txt · Last modified: 2023/10/05 00:35 by dmitry