Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

MostFrequentTerm ( theList )

Yields the most frequently-occurring term in a list of values.

  Be the first to rate this function Log in to vote

Brian Panhuyzen - Show more from this author Neutrino Data Systems https://neutrinodata.com

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

/* MostFrequentTerm ( theList ) v1.0 • 30 November 2021 • Toronto by Brian Panhuyzen Neutrino Data Systems https://neutrinodata.com Yields the most frequent term from a list of values. Will work only with FileMaker 18 or later, since it uses the recursive While function. */ While ( [ i = 0 ; ~Result = "" ] ; i < ValueCount ( theList ) ; [ i = i + 1 ; ~Result = Let ( ~Term = GetValue ( theList ; i ) ; If ( not PatternCount ( ~Result ; ~Term ) ; List ( ~Result; ~Term ) ; List ( ~Term; Substitute ( ~Result ; ~Term & ¶ ; "" ) ) ) ) ] ; GetValue ( ~Result ; 1 ) ) Click to copy

Provide the function with a list of values that includes repeating terms, and it will yield the most frequently occurring term. A tie in most-frequent terms (e.g., two or more terms occur with the same frequency) will result in only the latest term in the list appearing.

The function can be adapted to show a list of all the terms in order of diminishing frequency by removing the GetValue function for the ~Result.

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: