Hi Everyone,
I have a process that sends error messages to the platform. I want to retrieve the most common error message and display that.
This is how the column looks like:
Here we have a column with 3 rows. We have one instance of Auto Extraction issue, and two with Mandatory fields.
I’d want the output of this dashboard to show:
“One or more of the mandatory fields were missing!”
as that is the most common error received.
How do I count the number of distinct strings in a column and display the max of that?
I have also access to the unique log ID if that helps. (without it in the dashboard, only distinct members will be shown so I have to use it)
Any advice is appreciated. Thanks.