https://docs.google.com/spreadsheets/d/1KvLy9TZ7UsxzNE-7IB_v7OCAI4rv58wL/edit?usp=sharing&ouid=107351716570025173091&rtpof=true&sd=true
IF [Event Time] <= {MAX([Event Time])} and [Event Time] >= {MAX([Event Time])-6}
then "last 7 days"
ELSEIF [Event Time] <= {MAX([Event Time])}-6 and [Event Time] >= {MAX([Event Time])-13}
then "previous 7 days"
END
{FIXED [User-Id],[Event Name],[Event Time],[Feed Id],[Tag] : COUNTD([Event Time])}
(IF [Event Name] = "feed_view" then [# of Event per User] end)
(IF [Event Name] = "follow" then [# of Event per User] end)
(IF [Event Name] = "like" then [# of Event per User] end)