We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Counting the amount of times the leading digit is a 1, 2, 3 etc

eletwat9999
5 - Atom

I am trying to count how many times the leading digit in a single grouping in my file is a 1, a 2, a 3, etc... I have no idea where to start on this and would love some help!

3 REPLIES 3
flying008
15 - Aurora

Hi,@eletwat9999 

 

Dear, maybe you can give some data-table to show your input and output.

ArtApa
Alteryx
Alteryx

Hi @eletwat9999 - Please see attached. This coupled with Benford Analysis: https://en.wikipedia.org/wiki/Benford%27s_law 

ArtApa_0-1676945523102.png

 

Raj
16 - Nebula

can you please share some sample data ?

Labels
Top Solution Authors