Skip to content
Adaptam Docs

MIN_COUNT

Calculates the lowest data field value count for single or multi-loop data field value groups, all subject to data field filters if desired. Where the output can be changed to the second, third or so on highest count. Where the output can also be changed to the corresponding loop field group value.

MIN_COUNT function overview

Function syntax

MIN_COUNT(COUNT input | Loop1, ... | filter1, ... | OUTPUT[field], RANK[n])

Arguments:

  • COUNT input: The data field to count.
  • Loop1, …: The data field to split the data (e.g., by product, by region) for the averages. Multiple loop fields supported.
  • filter1, …: (optional) The data field and value(s) used to limit the data. Can reference a cell (including DROPDOWN cells) for the field filter value.
  • OUTPUT[field]: (optional) Select the loop field corresponding value as the output instead of the count.
  • RANK[n]: (optional) Return the Nth lowest count instead of the minimum (e.g., RANK[2] for second lowest).

Examples

  • MIN_COUNT(sales | product) - Lowest count of sales transactions by product.
  • MIN_COUNT(sales | product | channel{“Online”}) - Lowest count of sales transactions by product, Online channel only.
  • MIN_COUNT(sales | product | | OUTPUT[product]) - Which product has the lowest count of sales transactions.
  • MIN_COUNT(sales | product | | OUTPUT[product], RANK[2]) - Which product has the second lowest count of sales transactions.
  • MIN_COUNT(sales | product, region) - Lowest count of sales transactions by product and region combined.