3 Replies Latest reply on Oct 9, 2018 12:26 AM by Adolfo Hernandez

    Simple Count Unique Value (with logic)


      hi all, was wondering if this is possible...



      To only count those [Xy ID] that appears in both 'Chat' and 'Voice' [Media Type]


      My attempt failed>

      IF  [Media Type]='Chat' AND  [Media Type]='Voice'

      THEN [Xy Id]

      ELSE 0



      Hope u guys can help~