Identify most common value and use that value to filter out non common values

crtakacs

I have a set of data that includes 'End Time'. The majority of the data will have a common 'End Time' value but each day that I run the report there will typically be a few outliers with a different 'End Time' that I want to exclude. But the non-common 'End Time' values will always vary in value.

Is there a way I can identify what the most common 'End Time" value is and then use that value to say all the data I want to include must equal that most common 'End Time'?

I thought about using the Summary tool. So in this case I only want to include data that has a EndTime of 2020-04-10 since it is the most common value. But I'm not sure how to go from here and identify data with this common value. 

fmvizcaino

Hi @crtakacs ,

I'm attaching an example showing how to do it with summarizing and sample.

Let me know if this works for you.

Best,

Fernando Vizcaino

2020-04-08 Identify most common value and use that value to filter out non common values.yxmd