https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
b

billions-house-96196

11/21/2023, 8:19 PM
Having trouble aligning a classic revenue metric to a fact table one. Any know issues, here? The only difference I can find in the queries is in
__userMetricAgg
where the fact table uses a coalesce() function. Otherwise metric definitions and settings are the same but query results are off 10%.
b

brief-honey-45610

11/21/2023, 8:27 PM
Hi Merritt, I'll look into this for you and run this by the person who launched the Fact Tables feature. I'll update you once I have more info. Thanks for reaching out!
b

billions-house-96196

11/21/2023, 8:32 PM
Thx!
h

helpful-application-7107

11/22/2023, 12:24 AM
Can you share more of the query information with us? It will help us know if they have different denominators, conversion windows, or other filters?
(also if you change the Column number type to currency you'll get the same currency formating for the fact table metric!)
b

billions-house-96196

11/22/2023, 3:21 AM
Thanks Luke. I'll DM you the full queries.
4 Views