3 Replies Latest reply: Mar 16, 2017 2:29 PM by Sasidhar Parupudi RSS

    aggr functionality to return a subset of results

    Maria Harmening

      I'm creating a table for my dashboard and only want to display BINS that are present and have someone in them. I did an aggr function and it's not working.  what am I doing wrong?

       

      aggr(distinct {$<BINPresent = {1}>} {$<BINUnmapped={0}>}, BIN)

       

      I understood this to return only the distinct BINS that have a binpresent of 1 and a binunmapped of 0.  am I using aggr incorrectly?  how can I return the BINs that I'm looking for?