2 Replies Latest reply on Sep 26, 2016 3:05 PM by margaret.quigley

    Quick Table Calculation - Difference; is there a table calculation that will include the difference between 0 and the first row in the table?

    margaret.quigley

      Margaret QuigleyVizitor

      Hello,

       

      I'm using the quick table calculation "Difference" to show the difference in views of an online video from one hour to the next. I see that this quick calculation doesn't show the difference between 0 and the first row collected (the difference between 0 and 120813). The first data point is just the difference between the first row collected and the second, so 145813. Is there a way to edit this calculation to additionally plot the difference between 0 and the first point? The calc comes out to: ZN(SUM([Org3Views])) - LOOKUP(ZN(SUM([Org3Views])), -1). I'm doing this for hundreds of videos.

       

      Here's an example of a column I'm working with (in reverse order) for one video:

       

      Org3 Views

      1317417

      1260150

      1207274

      1143502

      1071132

      1000247

      922548

      843725

      767716

      694327

      628383

      554846

      471191

      382025

      266626

      120813

       

      Thanks!

      Margaret