Average by group/category

etchiou

Hello! I have sorted a column in my data so that it lists different sports in ascending order. How do I proceed to calculate the average value (from the airfare price column) of each sport and then create graphs from that? Similar to a SUMIF/IF/AVG statement in Excel. Thank you in advance! Attached is what I have so far. 

Airfare - Alteryx.yxmd

DataNath

No problem @etchiou - thanks for providing that! Are you looking for something like this?

To do aggregations in Alteryx, we use the Summarize tool. In your case, you want the average amount by Sport and so we group by Sport, before taking the Average of amount:

To create charts, we can then utilise the Interactive Chart tool. Here I've just made a new layer, set it to a bar chart and selected which fields I want on each axis:

To then view the final outcome, I've simply added a Browse tool afterwards. If you want to output this, you can use the Reporting (orange) tools to do various things with this i.e. create emails/reports etc.

Any other questions or if you were looking for something different then please let me know!

Average airfare by sport.yxzp