Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Greater than or equal to a variable (set analysis)

Hello,

I am trying to find the set analysis that will only produce a value when a date field is greater to or equal to a variable I have set. I know how to make it equal to a variable however that is the extend of my knowledge. Here is what I have so far

Only({$<DateField={'$(variable)'}>}  Name)

Is there a way to make the set only look at values greater to or equal to the variable.

Thank You!

3 Replies
pbaenen
Contributor III
Contributor III

Try this:

Only({$<DateField={">=$(=$(variable))"}>} Name)

MayilVahanan

Hi,

     Try like this,

    

     =Concat({<DateField = {'>=$(variable)'}>}Distinct Name,',')

     If you use only here, you will get null value, because, if only one value is occur only produce result..

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks! That solution worked perfect for me.