Most property math aggregations aren't implemented

[danielbachhuber]

The following operations simply return the sum:

• min
• max
• median
• p90
• p95
• p99

See:

posthog/posthog/hogql_queries/experiments/test/test_experiment_trends_query_runner.py

Lines 1557 to 1651 in 80db493

	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_min(self):
	self._test_query_runner_property_math(
	math="min",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)
	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_max(self):
	self._test_query_runner_property_math(
	math="max",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)
	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_median(self):
	self._test_query_runner_property_math(
	math="median",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)
	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_p90(self):
	self._test_query_runner_property_math(
	math="p90",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)
	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_p95(self):
	self._test_query_runner_property_math(
	math="p95",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)
	@freeze_time("2020-01-01T12:00:00Z")
	def test_query_runner_property_math_p99(self):
	self._test_query_runner_property_math(
	math="p99",
	expected_control={
	"count": 5,
	"absolute_exposure": 5,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0],
	},
	expected_test={
	"count": 10,
	"absolute_exposure": 10,
	"data": [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 10.0, 10.0, 10.0, 10.0],
	},
	)

From #26952

Done is:

• These operations return their expected values.