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

Averaging Grouped Data in Dataset

krich434
6 - Meteoroid

Hello all - have a question on a data set where I'm trying to average numbers based on a grouping. Below is my data set:

 

krich434_0-1668535373926.png

 

 

Here is my desired output:

 

krich434_1-1668535383318.png

 

I cannot find my solution via Summarize because it's dropping the scores for each category. Any way around this?

 

Thank you!

4 REPLIES 4
ShankerV
17 - Castor

Hi @krich434 

 

It can be achieved. Will help on it.

 

Shanker V

Felipe_Ribeir0
16 - Nebula

Hi @krich434 

 

One way of doing this (used dummy numbers)

 

Felipe_Ribeir0_0-1668535636775.png

 

krich434
6 - Meteoroid

This worked - thank you! Simple solution I wasn't seeing. 

ShankerV
17 - Castor

Hi @krich434 

 

Please find my solution as expecting in your output.

 

ShankerV_0-1668536921495.png

 

1. Used the summarize tool as you did.

2. Use the union tool with Manually Configure Fields

3. Use the Sort tool to sort as if we have the sub total.

4. Use the Filter tool with the highlighted formula or to replace some kind of replace text stating Auto Subtotal.

 

Let me know if you need additional support.

 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

 

Many thanks

Shanker V

 

 

Labels