Start Free Trial

Alteryx Designer Desktop Discussions

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

Add row with count formula

sharmilaj
7 - Meteor

Hi,

 

I'm trying to add a row at the end of my Alteryx results showing count of data present.

Kindly help with this. Thanks. 

My result :

TYPEPERCENTAGEREMARKS
A30 
B40 
C12 
D55 
E63 

 

Desired output

TYPEPERCENTAGEREMARKS
A30 
B40 
C12 
D55 
E63 
Count 5 
2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @sharmilaj ,

 

One way of doing this. I hope this helps.

 

Workflow

Yoshiro_Fujimori_0-1687319893267.png

 

Output

Yoshiro_Fujimori_1-1687319915093.png

 

sparksun
11 - Bolide

It's simple to just use Union tool

sparksun_0-1687320434482.png

 

 

Labels
Top Solution Authors