Brian Dunning's FileMaker Custom Functions

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   Brian Panhuyzen - Show more from this author
Neutrino Data Systems
https://neutrinodata.com

Share on Facebook Share on Twitter

  Sample input:
MostFrequentTerm ( "Dog¶Cat¶Mouse¶Dog" )
  Sample output:
Dog

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

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 16 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: