Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Running Total & Sorting

Bonediggler
9 - Comet

Experts!

 

Does the Running Total tool automatically sort data by the values selected to Group By?  I know this happens with the summarize tool but it doesn't seem to be documented.

 

If so, it would be unnecessary to sort the data before sending it through the Running Total tool - correct?

 

Thanks in advance!  

1 REPLY 1
mceleavey
17 - Castor
17 - Castor

Hi @Bonediggler , Outstanding name. Fine work.

 

In short, yes. The Running total tool uses whatever order you have in the data when it goes into the tool, and will create a a running total of a given column(s) from row one down, taking into account the grouping function.

If you don't use Group By, it will start on row 1 and simply create a running total.

If you use the group by, it will then create the groups by that field, sorted as they are, then do the same.

 

M



Bulien

Labels