2 Replies Latest reply: Nov 22, 2016 12:35 PM by francesco bellucci RSS

    count of distinct costumer in units greater than 3

    francesco bellucci

      I need to display in a chart dimension that repeat values over 3 times.

      I try to solve my problem using "if" but and sum result but there is an error in expression.


      Dimension of chart: [BUSINESS UNIT]


      sum(AGGR(IF(Count ({(<[RAPP NDG] ={'*'}>) + ( <[RAPP COI] ={'*'}>) } DISTINCT [COSTUMER])>3, 1,0),[COSTUMER]))


      I think that I need to solve problem with set analysis.