seth_e

@GrantSmith I fixed the sintax error with the code below but now it's only returning 1 user session per customer, which isn't correct. Any ideas what I can do? COUNT(DISTINCT Case When Start>= MIN(DATE(Start)) FIXED () AND Start< DATE_ADD(Min(DATE(Start)) FIXED (),INTERVAL 1 Year) THEN Session ID END)

in How do I set up a Beast Mode to count distinct events within a date range? Comment by seth_e December 2023

Thanks Grant, when I try this I get a syntax error

in How do I set up a Beast Mode to count distinct events within a date range? Comment by seth_e December 2023

I'm getting a syntax error

in How do I set up a Beast Mode to count distinct events within a date range? Comment by seth_e December 2023

seth_e Member

Comments