Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
someone here just helped me out with the return of a straight table where I needed a calculated dimension to filter only the very top and the very bottom dataset of a value:
=Aggr(Only({<ActionNo. = {$(=Concat(Aggr(Min(ActionNo.),QueueNo.),',')),$(=Concat(Aggr(Max(ActionNo.),QueueNo.),','))}>}ActionNo.), ActionNo., QueueNo.)
What strikes me is that, why the concat() function doesnt need a double quote to initiate a search? Does not a the dollar sign expansion within the curvy bracket of a set expression always need to be initiated into a search?
Hope someone can explain to me.
Thank you very much.
I believe it is because the resulting set expression is not searching the data set; it is looking for distinct values that your concat expressions are feeding the set expressing.
when you are searching you are using > or < or a wildcard; then you would need double quotes, but in your set expression the concat fields are being generated as a comma separated list of distinct values.
Hi @Applicable88
$(=Concat(Aggr(Min(ActionNo.),QueueNo.),',') <-- Its concatenate the minimum of Action No based on QueueNo and we're not searching here. We're assigning the values.
$() <-- its evaluates the values.
I believe it is because the resulting set expression is not searching the data set; it is looking for distinct values that your concat expressions are feeding the set expressing.
when you are searching you are using > or < or a wildcard; then you would need double quotes, but in your set expression the concat fields are being generated as a comma separated list of distinct values.
Hi @Applicable88
$(=Concat(Aggr(Min(ActionNo.),QueueNo.),',') <-- Its concatenate the minimum of Action No based on QueueNo and we're not searching here. We're assigning the values.
$() <-- its evaluates the values.