I am having issues creating a field that is a running total of another. I am using "group by" in the load statement to get engagement by date. I either get a very large number, or the same number as the engagement field. Here is simple example:
Date Engagement Total Engagement
1/1/17 4 4
1/2/17 5 9
1/3/17 16 25
After I get the running total, I need to find the date where the total hits the engagement goal, which will be the 4th field (not shown).