My list contains products and records their Types.
I want to determine which Type has the highest count in the list and return the Type value.
How should I do this?
Calculated From List
FlexSim 25.0.1
Hi @JulieLin, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.
You could use the following (only works if the list is global and not partitioned). It creates a table that contains all types and how often they appear on the list in descending order. Thus, if the result table is not empty, the first cell contains the most commen type.
Table result = Table.query("SELECT Type, COUNT(Type) AS NumOfType FROM List1 GROUP BY Type ORDER BY NumOfType DESC");
if(result.numRows > 0) {
return result[1][1];
}
return 0;
14 People are following this question.
