Question

Count the number of times a string appears in a column

  • 17 November 2021
  • 0 replies
  • 39 views

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.


0 replies

Be the first to reply!

Reply