1 Reply Latest reply on Apr 16, 2018 11:04 AM by Yuriy Fal

    Calculate Date Diff between two dates; Get sum of difference of dates;

    Victor Sanabia

      Hello!

       

      I'm on Tableau 10.5,

       

      I'm trying to calculate the average time between two dates for actions taken by an individual and then take the average by doing a sum of total days difference / total number of actions.

       

      I need to be able to see each action as well as the number of days in between each action as well as the aggregate average at the individual level.

       

      Right now I have the average days in between an action per individual but I get null when I try to do the aggregate calculation.

       

      I have attached a workbook.

       

      I'm trying to get this: Average Velocity being sum of date difference / actions

      IndividualAverage Velocity3/2/20173/5/20173/11/2017
      Child2.7BrowsedPlayed
      3

      Played 2

      4

      Parent.5Bought