DistributionTR ( uniqueList ; dataList )

For each item in list 1, counts occurrences in list 2

Average rating: 4.4 (37 votes) Log in to vote

Bruce Robertson - Show more from this author

Sample input:

DistributionTR( "A¶B¶C"; "A¶A¶A¶B¶A¶B")

Sample output:

A 4
B 2
C 0

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Distribution( uniqueList; dataList)
modified 3/17/2011
simple tab and return delimited list
Bruce Robertson
Concise Design
*/

Case( 
IsEmpty( uniqueList); "";

Let([
v1 = GetValue( uniqueList; 1) ;
listLength = ValueCount( uniqueList ) ;
matches = ValueCount( FilterValues( dataList; V1));
listremainder = MiddleValues( uniqueList ; 2; listLength -1) ];

V1  &  Char(9) & matches & "¶" & 
DistributionTR ( listRemainder; dataList ) 
)
)

Simpler output than original function; tab and return delimited, no highlighting.

For each item in list 1 (uniquelist) , counts occurrences in list 2 (datalist). So for instance list 1 could include Seattle and Portland, and list two could be the result of a list function that accumulates the "City" field across a record set.

Comments

		Gmal, New York May 29, 2013
Is there a way to sort the resulting list by the occurrence values?

		Bruce Robertson May 29, 2013
That's left up to you. Could be done easier now with ExecuteSQL anyway.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

DistributionTR ( uniqueList ; dataList )

Comments

Support this website.

Support this website.