full-island-88199
11/29/2022, 3:11 PMfuture-teacher-7046
gray-crayon-34592
12/01/2022, 11:08 AMLEAST
is used (it is shown when clicking on "View Queries" in the Info panel of the metric):
__userMetric as (
-- Add in the aggregate metric value for each user
SELECT
LEAST(1, SUM(value)) as value
FROM
__metric m
GROUP BY
m.user_id
),
and it is very odd because when we run the query up until here and with only positive numbers in value
we get the attached results (in Snowflake).SUM(value) as sum_value
)least
was there due to having a 1
in the cap value, but the problem still remains. We will investigate more.