looped calculations using values of a column after subsetting by different factors (categorial)

Hi @kguehrs and welcome to the forum.

Based on your description, this sounds like a job for some combination of the following nodes:

  • Group Loop Start
  • Statistics
  • Math Formula (or if conditional logic is needed, perhaps Column Expressions)
  • Normalizer
  • Loop End

Here’s a sample workflow from the Hub that demonstrates some of these nodes in practice - in particular, the looping function.

If you can provide a dummy dataset and some sample calculations you’d like to perform, perhaps someone could help come up with a workflow more tailored to your needs.

1 Like