SOLVED

Does the "between" filter option include the extremes of the range?

Go to solution
Victor_Herrero
Level 5

Does the "between" filter option include the extremes of the range?

Hi,

Here is a snapshot of what I'm trying to achieve

pastedImage_0.png

I am setting up ranges but I'm confused about what they currently look like.

Here is what I really want:

Ready: [20 - ... ] || equal to 20 or greater

Need time: [0 - 19] || between 0 and 20, including 0 but NOT 20

Not for you [(-...) - (-1)] || any negative values

Is this what my campaign is actually doing?

Basically: does Marketo include extremes in ranges or not?

1 ACCEPTED SOLUTION

Accepted Solutions
Gerard_Donnell4
Level 10

Re: Does the "between" filter option include the extremes of the range?

Between includes the start and end date when using it with the date filter so I am assuming it would be the same on scoring fields.

UPDATE:

Just did a test using a score field and it does indeed include the extremes of the range. So, in your example the filter would include -1 and 21.

View solution in original post

6 REPLIES 6
Gerard_Donnell4
Level 10

Re: Does the "between" filter option include the extremes of the range?

Between includes the start and end date when using it with the date filter so I am assuming it would be the same on scoring fields.

UPDATE:

Just did a test using a score field and it does indeed include the extremes of the range. So, in your example the filter would include -1 and 21.

Victor_Herrero
Level 5

Re: Does the "between" filter option include the extremes of the range?

Thanks for your answer! Sorry it took so long. Both answers are correct, so I don't know if I can or how to mark both.

So basically "Between" is inclusive. Thanks!

Karan_Hari3
Level 9

Re: Does the "between" filter option include the extremes of the range?

Hi Victor Herrero​,

Here is an explanation for your case

  • pastedImage_1.pngpastedImage_3.png

In this case, using greater than would mean  - Above the specified Value. So if you want equal to 20 or greater, the correct operator should be "at least" - Which means - Above the specified (Inclusive)

  • pastedImage_6.pngpastedImage_7.png

In this case again using between would mean - Define two value to find everyone in between (inclusive). So from what is defined, it will include every one including -1 and 21. The correct option should be "Between - 0 - 19" That would make sure 0 is included and 20 is not included

  • pastedImage_11.png

This option is defined Correct! "Less than" means  - Less than Specified.

For future reference you can use the Smart List Filter Operators Glossary​ which explains all the operators in detail.

Hope this helps.

Best Always,

Karan Hari

Karan Hari
Senior Product Manager - Marketo Engage
Karan_Hari3
Level 9

Re: Does the "between" filter option include the extremes of the range?

Hi Victor Herrero​,

Trust you are doing great! Just wanted to circle back and check if your query was resolved and if the article mentioned above was helpful. Kindly let me know in case you require any further help.

Best Always,

Karan Hari

Karan Hari
Senior Product Manager - Marketo Engage
Victor_Herrero
Level 5

Re: Does the "between" filter option include the extremes of the range?

Hi Hari,

Thank you for the in-depth answer. You are both correct. I just marked the previous answer because Gerard replied first.

Thanks for sharing the correct documentation as well. 

Best regards,

Victor

Karan_Hari3
Level 9

Re: Does the "between" filter option include the extremes of the range?

Hi Victor Herrero​,

Sure. Glad your query was resolved. Happy to help

Best Always,

Karan Hari

Karan Hari
Senior Product Manager - Marketo Engage