full-island-8819911/29/2022, 3:11 PM
gray-crayon-3459212/01/2022, 11:08 AM
is used (it is shown when clicking on "View Queries" in the Info panel of the metric):
and it is very odd because when we run the query up until here and with only positive numbers in
__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 ),
we get the attached results (in Snowflake).
SUM(value) as sum_value
was there due to having a
in the cap value, but the problem still remains. We will investigate more.