calculating counts using set analysis

[ManiSK]

HI 

Can someone help me on below query?

i want to calculate the counts with below conditions

less than GRANT_DATE which i'm selecting + INELIGIBLE = N + RISK =[HIGH]

=count({$<GRANT_DATE ={"<=$(=GRANT_DATE)"}>+1<INELIGIBLE={'N'}>+1<RISK={'[HIGH]'}>}ENTITLEMENT_UNIQUE_ID)

And also wanted to know whether its possible to allow the user to update GRANT_DATE in the variable in dashboard and  calculate the counts?

Thanks,

[rubenmarin · Accepted solution]

Hi, the '+' between sets (defined by < and >) will be considered as an 'OR', if you want an 'AND' * can be used, but in this case maybe you only need to do a single set with fields separated by commas:

=count({$<GRANT_DATE ={"<=$(=GRANT_DATE)"}, INELIGIBLE={'N'}, RISK={'[HIGH]'}>}ENTITLEMENT_UNIQUE_ID)