MEDIAN

MEDIAN([Price] + ([Price] * [Tax Rate])/100)

Syntax

MEDIAN(numerical expression)

Aggregation function returns the median of values calculated using numerical expression.

numerical expression: Basic arithmetic calculation created using the math operators +, -, *, /, numerical data fields and constants.

Use cases

Spent time on tasks

Compare median spent hours for completed tasks per week.

Source: Tasks

Time tracking stats for tasks of the building super hero suit

Completed OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

Chart BAR

X: MONTH([Completed On])

Y: MEDIAN([Hours Spent])

Chart

MONTH(Completed On)MEDIAN(Hours Spent)
January, 201832
February, 20183.5
March, 20185