4 Replies Latest reply on Oct 18, 2013 10:54 AM by Ramon Martinez

    Running Totals Partitioned

    Kito Patterson



      I would like to create a running total column based on a column in my data set. However, I would like this running total to start over again every time there is a new date and user id.


      I have a Day, BT_Date, User_ID and Visit columns. I want the running total to accumulate for each day [Day] until the BT_Date changes then start the running total over again based on those visits for that Unique_ID. That running total should should start over again by date within each Unique_ID or partitioned by both. I've attached an example data set. Is this possible and if so how would I go about creating that metric in my data set.