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. 

[DataNath]

Hey @etchiou, can you attach the actual Excel file that's used as the Input as well? Unless you export a packaged workflow, assets like the data files etc aren't contained within them!

[etchiou]

Hi @DataNath - thanks for bring that to my attention! I have attached a simplified Excel data file. Thank you!

[DataNath · Accepted solution]

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!

[binuacs · Accepted solution]

@etchiou One way of doing this

[etchiou]

Thank you!! Exactly what I was looking for!! Appreciate it!!