Unless I’m missing something, the only way to use relative dates is in cohort creation based on event triggering. There is no way in cohorts or reports to do a relative date comparison of event/user properties values.
eg. We track user signed up date using the “created_at” user property like most do.
it’s so natural to want to create a report that filters on users with “created_at within last 30 days”.
the only way to do this is to create a cohort based on completion of our “sign up completed” event, then using that cohort in a report’s segment filters. While this works it’s roundabout and forces you to create cohorts when you may not need them for different reports.
additionally it’s not always possible in every scenario to have a corresponding event that works for this. Eg. Users may have a date property thay precedes the creation of the event or say if amplitude was deployed after the user had signed up (so there would be no event but there would be user properties).
am I missing something or is there no way to do filters based on relative date comparisons?
