3 Replies Latest reply on Jun 6, 2013 1:31 PM by Mark Holtz

    How do I calculate Date Difference from previous row in partition?

    nick.stuchbery

      As you can see in my attachment, I have a main grouping, then further divided by day and hour.  How do I calculate the difference in days from one row to the next within my main grouping (it's not displayed well in my screen cap)??   Tried many things but nothing seems to work!! I could do this easily in Excel, but it has me stumped here:)

       

      Thanks very much!  Nick