2 Replies Latest reply on Mar 8, 2017 8:49 PM by Shinichiro Murakami

    Logical Lookback Calculation

    Phillip Black

      I'm interested in calculating how many people who had 7 or more days of inactivity yesterday came back today.


      My x-axis is the date and my strategy was the following calculated field,


      SUM(IF [date] - 1 AND [days_since_last_activity] >= 7 THEN [daily_active_users] END)

      but of course date - 1 is never a true statement. What I want to say is:


      SUM(IF day_since_last_activity] >= 7 WHEN yesterday THEN [daily_active_users END)


      Any recommendations on how to do this in Tableau?