Alteryx Designer Desktop Discussions

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

Generate Row which count number of Trues.

Evils
6 - Meteoroid

Hello everyone :) 

 

I'm new to alteryx, but there is a problem I can't get my head around it. 

 

I want to count how many times "True" is  occurring in a specific column, then generate a row which append the number in the end of the column, like shown beneat

Data fieldValue
ATrue
BTrue
CFalse
DTrue

 

The result: 

Data FieldValue

A

True
BTrue
CFalse
DTrue
Total True's3

 

I know it is possible in Excel, like shown beneath:

 

Udklip.PNG

 

Hope you guys can help me.

 

Thank you :)

 

 

 

 

 

 

 

 

 

 

 

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
Sorry for a text solution but here it comes.

1. Filter for value='true'
2. use Summarize to get count
3. Union manually configured to add the record
4. Use a formula to get text right.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels