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
where the fact table uses a coalesce() function. Otherwise metric definitions and settings are the same but query results are off 10%.
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!
11/21/2023, 8:32 PM
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!)
11/22/2023, 3:21 AM
Thanks Luke. I'll DM you the full queries.