Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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