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!

Alteryx Designer Desktop Discussions

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

Summarize Max volume and get price

TomCurran
6 - Meteoroid

I need to get the price from the max volume for market, brand, and size. I have this solution and have checked it, but I question whether or not this actually is the way to go about this.

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

It appears to work fine!

An alternative would be to use the sample tool after your sort. Grouping by Market, Brand and Size and returning the last 1 record.

 

What i'd be most wary of is what happends if you have a combination which has the same volume but a different price, is that possibe?

See attached.

Ben

TomCurran
6 - Meteoroid

Ben,

Thank you, and yes I was concerned about a combination which has the same volume, but I have to check with my requester as to how he would like to handle that case.

Labels