I tried using table calculations but realized it became very complicated very quickly trying to compare the averages across the month. In an attempt to work smarter and not harder, I realized I could calculate the number of days between orders in Tableau Prep and then pull it into Tableau for analysis. However, Tableau Prep does not have a native LAG() function but using some of the recent formula updates to Tableau Prep, we can mimic the LAG functionality.