Hey, is it possible to remove the metric timestamp...
# ask-questionsp
powerful-hydrogen-69787
11/17/2023, 12:17 PMHey, is it possible to remove the metric timestamp (
m.timestampd.timestampm.valuer
rhythmic-agent-34208
11/17/2023, 12:17 PM⭐ Our official support hours are 6:30am - 5pm Pacific Time, Monday through Friday. You may occasionally hear from us outside of these hours.
Your support request has been logged in our system. Our support team will get back to you very soon!
r
ripe-optician-43107
11/17/2023, 12:20 PMP.S. The screenshot is from the full query that GrowthBook runs when calculating the results and it automatically includes the filtering that Laura mentioned and that we want to exclude
b
brief-honey-45610
11/17/2023, 2:59 PMHi Laura and Paulius, thanks for reaching out! I’ll ask the team about this and get back to you soon with an update
🙏 1
🙌 2
r
rhythmic-agent-34208
11/17/2023, 8:19 PMHi, could you please send me a screenshot of what you did before, but with the rest of the dashboard page in view? You can block out any sensitive info. Thanks!
rhythmic-agent-34208
11/17/2023, 8:19 PMIf you could also explain more about your use case that would help me determine what we can do
p
powerful-hydrogen-69787
11/20/2023, 7:29 AMHey, here is the screenshot of the dashboard.
powerful-hydrogen-69787
11/20/2023, 7:37 AMSo, our goal is to have a metric and use it as denominator in other metrics. We need to calculate clients created during Phase period (Oct 25 - now), and we have client created date as timestamp in a metrics query and it's being filtered by Phase date ranges. However, by default, metric value is filtered by first_exposure_timestamp (m.timestamp >= d.timestamp) which is higher than client creation date and it messes our results.
powerful-hydrogen-69787
11/20/2023, 7:41 AMI'm also attaching the full query from the results page for the mentioned metric.
r
rhythmic-agent-34208
11/22/2023, 12:43 AMHi Laura, my apologies for the delay! I was able to connect with our Data Scientist about your questions related to the timestamps.
The short answer to your question is "No, not safely."
A hacky workaround would be putting a huge negative conversion delay and a huge positive conversion window to ensure the date logic doesn't drop any rows. We wouldn't recommend this, though, unless you're very confident the resulting SQL achieves your goals.
p
powerful-hydrogen-69787
11/22/2023, 7:14 AMThanks! 🙏
24 Views