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]


      Expression

      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.