Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone!
So I have this expression, and I was wondering if there is a way to use a filter within that expression. For example:
this is my expression:
Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)
So what I would like to do is to provide a user with a filter so that the user can choose "ItemCon"; I would like to enable the user to either choose nothing: so the expression will be like:
Count({$< StatusesId = {1}, >} distinct RequestId)
or allow the user to specify a value for ItemCon to be excluded:
Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)
or allow the user to specify a value for ItemCon to be included:
Count({$< StatusesId = {1}, ItemsCon ={16}>} distinct RequestId)
Your help is appreciated!
Thanks!
Try this may be:
for excluding selection
Count({$< StatusesId = {1}, ItemsCon = e(ItemsCon)>} Distinct RequestId)
Wait, how will the expression should know when to include and when to exclude? Are you be going to use two states to do this?