Hi All,
I'm trying to add the previous cell to get the total to date but having a bit of trouble figuring out how to go about this one?
essentially, I want Day 1=Day1, Day 2= Day2+Day1, Day3=Day1+2+3 and so on.
Any ideas here? Picture attached for an idea.
Solved! Go to Solution.
@DigitalAdam
Sounds you need a running total tool.
The date is 1, 2,3, 4,5?
Ah yes, I need a running total tool. Is that a standard tool within Alteryx?
Edit: I'm seeing it, but by using it this is what I'm getting. It doesn't appear to be adding the numbers together
Thanks! Did you see my edit above perhaps? Trying to mess around with different groupings but not seeming to work as expected.
I think for the Running Total to work you might have to change the layout of the data such that the Day numbers are column values. Like so:
You can use the running total tool on this by grouping by "adjusted_track". Hope this makes sense.