Getting started
Use cases
Step-by-step instructions
Concepts
- Service overview
- Connection
- Data types
- Datasets
- Charts
- Dashboards
- Using Markdown in DataLens
- DataLens Public
- Calculated fields
  - Overview
  - Formula syntax
- Marketplace
- Backups
- Quotas and limits
Access management
- Managing access to DataLens
- Managing access at the data row level
Pricing policy
- Current pricing policy
- Archive
  - Rules before March 1, 2021
Function reference
- All Functions
- Aggregate functions
- Date/Time functions
- Geographical functions
- Logical functions
  - Overview
  - CASE
  - IF
  - IFNULL
  - ISNULL
  - ZN
- Mathematical functions
  - Overview
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEILING
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - GREATEST
  - LEAST
  - LN
  - LOG
  - LOG10
  - PI
  - POWER
  - RADIANS
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SQUARE
  - TAN
- Operators
- String functions
- Text markup functions
- Time series functions
- Type conversion functions
- Window functions
  - Overview
  - AVG
  - AVG_IF
  - COUNT
  - COUNT_IF
  - FIRST
  - LAG
  - LAST
  - MAVG
  - MAX
  - MCOUNT
  - MIN
  - MMAX
  - MMIN
  - MSUM
  - RANK
  - RANK_DENSE
  - RANK_PERCENTILE
  - RANK_UNIQUE
  - RAVG
  - RCOUNT
  - RMAX
  - RMIN
  - RSUM
  - SUM
  - SUM_IF
- Function Availability
Questions and answers

ARG_MAX

Written by

Syntax

ARG_MAX( value, comp )

Description

Returns value for the maximum value of comp in the group. If multiple values of value match the maximum value of comp, then the first one encountered is returned. This makes the function non-deterministic.

Argument types:

value — Any
comp — Any

Return type: Same type as (value)

Examples

ARG_MAX([Sales], [Profit])

Data source support

Materialized Dataset, ClickHouse 1.1.