Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add Product to Summarize tool

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!

14 Comments
DultonM
11 - Bolide

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
5 - Atom

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

bbolelli
5 - Atom

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

deberryc
6 - Meteoroid

Would love a product tool!

pineapplepig
5 - Atom

Would love this!

Hugo
9 - Comet

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
Alteryx Community Team
Alteryx Community Team
Status changed to: Under Review

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
8 - Asteroid

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
Alteryx
Alteryx
Status changed to: Accepted

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 😁