Random Sample Selected with criterias

Question

Hello

I am working on with a set of data that contains Date (YYMMDD) from 1990 - 2020. I would like to pick random samples from this population based on these criterias:

1. Population is from Year 2020

2. Population of 1 requires 1 samples

3. Population of 10 requires 5

4. population > 20 requires 15 samples, which samples have to be well distributed from Jan 2020- Dec 2020

5. The sample selected should be in (DDMMYY) format.

Below is the example of the dataset:

Date200807200807200807200807200814200818200825200903200923200923201005201005201006920626930313931201941006970620970910980807980807990111990510990617991231991231

Thank you so much for your help in advance.

afv2688 · Answer

Hello @alkafalhas ,

On the bottom of the action tool you will be able to see the formula itself.

What I did select is the second value, where it says "NNumber value=1000", what this does is modify that parameter (1000) based on the conditions of the formula.

Regards

alkafalhas · Answer

Hello @afv2688

Thank you for the explanation. However, do you mind to explain to me the process flow here?

How did you put the characteristic of the amount of rows?

Thank you so much for your help.

afv2688 · Answer

Hello @alkafalhas ,

Given your explanations and what I did understand from them this is what it does:

* Transforms the data into dates
* filters out those dates which differ the year from 2020
* given the amount of rows:* 1 - 9 gets 1
* 10 - 19 gets 5
* 20 - inf gets 15

The logic for the sampler is implemented within the action tool in the macro.

If you need anything else let me know

Regards