Forum Discussion
Team Trend Assistance
I'm not certain about your sample data but it looks like your goal is to determine the most frequently occurring text item(s) by team -- essentially a Mode Text w/1 criteria.
This Lambda will do it:
Mode.Text = LAMBDA(crit_range, crit, texts,
LET(
include, FILTER(texts, crit_range = crit),
occ, XMATCH(include, include),
common, IFERROR(MODE.MULT(occ),0),
SORT(XLOOKUP(common, occ, include, include))
)
)Patrick2788 thank you! I'll try to use that. I'll also provide a better explanation.
We're currently working in a call center. We monitor calls and grade them based on a set list of do's and don'ts. I'm trying to create a formula/function to monitor each agent's specific penalties to identify a trend amongst their team. So, if they were evaluated and received an infraction, we're adding their penalties to the tracker (as seen in the image below).
We're trying to monitor all of the infractions and pull the data to identify the main trend, per supervisor's team. Example: If all agents on Supervisor James' team are captured not ready to receive the call, we need to be able to see that as that team's main trend to address them appropriately. (see the second image below)
