Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Is it possible to have a count and sum in the same summarize tool?

lukestachowski
5 - Atom

I have a count column in my summarize tool, but I would also like to get the sum of the total count from each row without using a second summarize tool to get the sum.

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @lukestachowski 

 

What you are asking is total possible

atcodedog05
22 - Nova
22 - Nova

Hi 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1604341133051.png

 

Workflow:

atcodedog05_1-1604341147048.png

atcodedog05_2-1604341166775.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

lukestachowski
5 - Atom

I want to sum all of my results for count. The count is counting non-numeric values. There are 10 rows that have a value for count, and I would like to sum all of these values.

atcodedog05
22 - Nova
22 - Nova

Hi @lukestachowski 

 

Count can count both numeric as well as non numeric. And in summarize you can work on more then 1 column simultaneously.

lukestachowski
5 - Atom

Yes, the count is counting non numeric values. This is happening in my summarize tool. I would like another column that is the sum of all of these count values.

atcodedog05
22 - Nova
22 - Nova

Hi @lukestachowski 

 

Can this workflow

Input:

atcodedog05_0-1604341800672.png

Summarize:

atcodedog05_1-1604341824736.png

2 different fields 

Output:

atcodedog05_2-1604341855083.png

 

atcodedog05
22 - Nova
22 - Nova

@lukestachowski 

 

Oh you want sum of count. I dont think its possible in a single tool since its different steps.

 

But your requirement is still bit unclear to me

Labels