red-mouse-1009
01/03/2023, 9:39 AMnice-tailor-78881
01/04/2023, 2:52 AMred-mouse-1009
01/05/2023, 5:44 AMred-mouse-1009
01/05/2023, 6:21 AMmodern-waiter-38896
01/05/2023, 6:43 PMfresh-football-47124
cool-airline-75608
01/06/2023, 1:29 PMdelightful-salesmen-16876
01/06/2023, 9:04 PMrhythmic-chef-84815
01/10/2023, 8:35 AMagreeable-hospital-75165
01/10/2023, 5:40 PMsome-planet-44104
01/11/2023, 8:58 AMfull-vase-45670
01/11/2023, 10:48 AMswift-helmet-3648
01/12/2023, 3:41 PMwhite-salesclerk-40048
01/15/2023, 1:23 PMclever-dog-90390
01/16/2023, 9:53 AMclever-dog-90390
01/16/2023, 9:54 AMbland-farmer-44393
01/16/2023, 2:35 PMsilly-crayon-99948
01/16/2023, 3:09 PMthankful-camera-8271
01/17/2023, 1:58 PMpurple-cat-95990
01/19/2023, 9:23 AMrefined-winter-89168
01/20/2023, 3:08 PMthankful-scientist-83252
01/20/2023, 8:50 PMlate-table-27080
01/22/2023, 7:57 AMminiature-smartphone-36403
01/23/2023, 6:41 PMsome-fireman-8739
01/24/2023, 6:54 PMwide-jordan-14758
01/24/2023, 9:14 PMSELECT
54 m.user_uuid,
55 m.timestamp as ts,
56 m.value
57 FROM
58 __metric m
59 JOIN __experiment u ON (u.user_uuid = m.user_uuid)
60 WHERE
61 m.timestamp >= u.conversion_start
62 AND m.timestamp <= u.conversion_end
63 GROUP BY
64 m.user_uuid,
65 m.timestamp,
66 m.value
means that multiple rows with the same user_uuid, timestamp and value will be counted as just 1. However, the value that we are counting can sometimes fire multiple times simultaneously but each fire should be counted distinctly. Have you encountered this before/is there a way around grouping by timestamp?
2. It seems that the results of the metrics queries in the UI are sometimes different than the totals calculated in the queries. For example, if you add the
sum(m.value) as m_sum
field to the final select statement in the metric query and run the query, m_sum
is off by 1 compared to what is shown as the total for the variant in the GrowthBook UI. Any idea why this might be?
3. Is the Risk evaluated against the control or the perceived "winner" for each metric? For one of my metrics, the Risk box is empty when the Control cell is selected in the "Risk of Choosing" drop down.brash-stone-46387
01/25/2023, 12:59 AMclever-hair-5481
01/25/2023, 12:39 PMbrief-football-97996
01/26/2023, 9:36 PMable-printer-57574
01/26/2023, 10:16 PMdebug
in the context is always false. is there a way to override this? trying to fetch a feature flag’s value in a staging env on our app always seems to be fetching from the production value on the growthbook UI 😓