set

[smilingjohn]

how do we include greater than today into below set analysis ,

=count({<[Level]={'N'},

[Gate={2}>}[customer])

Regards

[Anil_Babu_Samineni · Accepted solution]

May be this?

=count({<Level={'N'}, Gate={2}, DateField = {"=DateField > Today()"}>}[customer])

[Anonymous]

count({<

[Level]={'N'},

[Gate]={2},

YOURDATEFIELD={">=$(=date(today()))"}

>}[customer])

[srishsum2017]

Today means the current date so how you compare by the today, because either somebody want data of today or previous days....so please first clear your question...

other wise expression for greater than is-

=countt({<Date={'>=Today()'},[Level]={'N'},[Gate]={2}>}[customer])

[Anonymous]

I think you can't use the syntax like that, even you do it like Anil or like me ...

[srishsum2017]

I am just giving an example how to use greater than in set analysis, other wise the best practice to store your dates which you want in variables, then use it.