Sampling Based on Different Criteria

[superace]

Hi,

Is there a way to sample the top N rows of data, based on a group, with variable requirements? For example, I have different criteria for how "deep" I want to sample based on an account #.

So account #1, for example, I'd like to pull the top 10 records but account #2 I'd like to pull the top 20 records. Sampling the top N rows based on a presort seems easy if it's universal (same criteria throughout) but I am not quite able to figure out how to do this based on different sampling criteria.

Any help would be appreciated.

Thanks!

[fmvizcaino · Accepted solution]

Hi @superace ,

Here is a suggestion to control a sample based on another dataset.

Let me know what you think about it.

Best,

Fernando V.