Replicating a For Each loop in Alteryx?

Bnstates

I'm fairly new to Alteryx and I'm trying to find a way to replicate a for each loop. I have data that I need to average the volumes of, but it has to be contingent on the as-of date. I'm looking for something that could help me do something similar to the following:

For Each As-Of-Date

If data = 1 then Average(volume)

ElseIf data = 2 then Average(Volume)

...

End If

Next As-Of_Date

Any help is greatly appreciated!

john_miller9

Looping in Alteryx is generally handled by using a macro.  However, from what you've provided it looks like this could be accomplished using a summarize tool configured as follows:

Group By: [As-of-Date]

Group By: [data]

Average: [Volume]

But it really depends on what your data looks like and the result you're looking to get.  Can you post a sample of the data?