4 Replies Latest reply on Sep 20, 2016 6:56 AM by David Li

    Cannot mix aggregate and non-aggregate comparison with COUN

    Tiet Thach

      Hello everyone,

      I am a newbie in tableau. I haven't still known why in my case as follows. Give me your idea about this issue:
      Question: I want to count the number of user who appear in list < 3.
      - First I created the "calculated Field"
      - Here is my function:

      If COUNT([User]) < 3 then [User] END 

      Finally, I count this Meseasure again to gain the final result.
      Here's my example:

      User 
      a
      a
      a
      a
      b
      b
      c
      b

      The result expected: 1 (only c)
      Thanks all,