Has anyone managed to get a custom user profile pr...
# questions
a
Has anyone managed to get a custom user profile property for the day of the week a user signed up? I know you can breakdown reports by a date, and specify breaking it down by the day of the week, but it'd be nice to eg be able to filter out weekend signups or Thursday evening sign ups as specific cohorts (we especially want to be able to measure the retention of these cohorts against each other etc). Was hoping to be able to at least use DATEDIF against a specific date and then %7 etc to determine which day of the week it is but haven't had any luck with eg
DATEDIF(Created, 1/1/2018, "D")
etc so far. Currently, feel like I might need to resort to a lookup table for dates to days of week as the easiest option...