Functions

​

SUM(expr)

• Adds values of expr across rows in each group.
• Example:
  FROM products
  SHOW SUM(total_sales)
  GROUP BY product_id
  SINCE -7d
  

​

COUNT(expr)

• Counts non-null occurrences of expr within each group.
• Example:
  FROM products
  SHOW COUNT(quantity_purchased)
  GROUP BY product_id
  SINCE -7d
  

​

COUNT(*)

• Counts all rows in each group.
• Example:
  FROM products
  SHOW COUNT(*)
  GROUP BY geo_country
  SINCE this_month
  

​

AVG(expr)

• Average of expr per group.
• Example:
  FROM products
  SHOW AVG(total_sales)
  GROUP BY product_id
  SINCE past_30_days
  

​

MIN(expr)

• Minimum value of expr per group.
• Example:
  FROM products
  SHOW MIN(total_sales)
  GROUP BY product_id
  SINCE past_90_days
  

​

MAX(expr)

• Maximum value of expr per group.
• Example:
  FROM products
  SHOW MAX(total_sales)
  GROUP BY product_id
  SINCE past_90_days
  

​

COUNT_DISTINCT(expr)

• Counts distinct non-null values of expr per group.
• Commonly used for session-based metrics.
• Example:
  FROM products
  SHOW COUNT_DISTINCT(view_sessions)
  GROUP BY product_id
  SINCE this_month