cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Count Function

PLEASE add a count function to Formula/Multi-Row Formula/Multi-Field Formula!

 

I have searched for alternatives but am just confused about how to store the result for the total number of rows from Summarise or Count Records in a variable that can then be used within a Formula tab. It should not be that difficult to just add equivalents to R's nrow() and ncol().

4 Comments
Alteryx Certified Partner
Alteryx Certified Partner

@helfenbeind,

 

When I have this need, I count the number of rows and append that value to every record (Append Fields).  

 

Cheers,

Mark

Meteoroid

Thanks for your reply, @MarqueeCrew.

Alteryx Certified Partner
Alteryx Certified Partner

That would be a good idea to suggest.  Please do.

 

https://community.alteryx.com/t5/forums/postpage/board-id/product-ideas

 

Cheers,

Mark

Alteryx
Alteryx
Status changed to: Comments Requested

Thanks for adding this idea @helfenbeind. I'm looking into adding some functions to Formula and will add this one to my list to consider. Can you tell me a little more about how you'd use this function? What problems would you solve with the function? Specific examples would be helpful.