Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm using a heat map object and the class function to display the number of associates by amount of overtime worked and transactions per hour. I'd like the mouse-over to display a list of associates falling within the various buckets.
I'm able to do this if there is only one associate in the bucket by adding a second measure "=Only(Assoc_ID)." In cases where there is more than one associate in the bucket, it only displays a "-" to indicate more than one.
Is it possible to display the array of associates as a comma delimited string when there is more than one associate in the bucket? If so, how would I do this.
Thank you for any assistance you can provide.
-Frank
Nevermind...figured it out
if(count(distinct Assoc_ID)>1,Concat(distinct aggr(Assoc_ID,Assoc_ID),', '),Only(Assoc_ID))
Nevermind...figured it out
if(count(distinct Assoc_ID)>1,Concat(distinct aggr(Assoc_ID,Assoc_ID),', '),Only(Assoc_ID))