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