This message was deleted.
# ask-questions
w
This message was deleted.
a
you can use sql templates in your metric definition to filter based on experiment duration https://docs.growthbook.io/app/metrics#sql-templates, for example:
Copy code
select
  min(timestamp) timestamp,
  session_id,
  anonymous_id,
  host,
  countIf(event = 'page_viewed') page_views
from events
where timestamp >= '{{ startDate }}'
  AND timestamp < '{{ endDate }}'
group by session_id, anonymous_id, host
having page_views < 2
h
ah thats excellent! I'll add those in. Thank you
133 Views