Running Total Question

[christinachau22]

Hi all, 

I'm still fairly new to Alteryx and was hoping to get guidance on running totals and % completion. Is it possible to replicate the last two columns?

[Bren_Spill2 · Accepted solution]

@christinachau22 - you can achieve the Cumulative Total with the Running Total tool in the transform palette. Make sure to group it by Action

[binuacs · Accepted solution]

@christinachau22 use the running total tool for your use-case, you can calculate the % completion with the formula tool

in the running total too select action field -group by and running total for the field count

[christinachau22]

Thank you everyone! This was extremely helpful.