Add Product to Summarize tool

[patrick_digan]

I would love to see a "Product" option added to the summarize tool. I can currently count, sum, mean etc., but I can't multiply my data while grouping. There are numerous "work arounds", but a native product function built into the summarize tool would be great.

Thanks for listening!

[DultonM]

It's been almost 2 years since @patrick_digan posted this idea, so I'd like to raise some awareness! Just today I was helping our new intern with his first Alteryx project. He needed to summarize his data by multiplying across the rows. The Summarize tool quickly came to his mind. Unfortunately, I had to tell him about this gap in the Alteryx Designer and show him a much less intuitive work-around.

[Alexh4]

I would love to see a product function for the summarize tool. any idea if this would likely happen. 

[bbolelli]

Seeing as this is not currently available, have you found a work-around for this?

[deberryc]

Would love a product tool!

[pineapplepig]

Would love this!

[Hugo]

Would be really useful in financial analysis - currently we multi row formula to create a running product and then take the last - very resource intensive

[KylieF]

Thank you for your post! Our product team is currently working through evaluating what sort of dependencies would be impacted or need to be adjusted for them to be able to implement this idea. While this is occurring, which can take some time, I'm updating this idea to Under Review. Once our team can better speak on if or when we could implement this idea I'll update the idea accordingly!

[leehaozhong]

I second this! What a useful tool this will be. However, please bear in mind if there are different signages, how will Alteryx summarise them.

For example a -7% and a +7% should cancel each other. While a +10% and -7%, should be a 0.1X0.93 = 0.093.

This is doing my head in. Hope someone can double verify this for me. 

[____________________]

The product is simple, if one models the notion of +n% and -n% correctly:

1.07*(0.93) = 0.9951

1.10*(0.93) = 1.023

[NicoleJ]

Thanks for the great idea, @patrick_digan ! We agree this would be a handy function to have in the Summarize tool, and will keep you posted when it is coming soon 😁