cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
SOLVED

Generate Row which count number of Trues.

Highlighted
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 :)

 

 

 

 

 

 

 

 

 

 

 

 

Alteryx Certified Partner
Alteryx Certified Partner
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 reboot. Order shall return.
Labels