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?

      Thanks!