4 Replies Latest reply on Mar 20, 2016 8:54 AM by Mahfooj Khan

    Find an unique user count for a particular subscriber

    mitra mohapatro

      I am trying to get a count of unique users that fall into a group.

       

      I have a subscriber that views one or multiple channels a day.I am having a particular Advertisement which telecasts through out the channels on that day.

       

      I need the unique count of users that views that particular advertisement in one channel only, example:

       

      Groups

      - User 1 has viewed that advertisement in HBO and STAR TV.

      - User 2 has only viewed that advertisement in HBO.

      - User 3 has only viewed that advertisement in STAR.

      - User 4 has viewed that advertisement in HBO and STAR TV and in ZEE network also.

       

      My query is I want to find out the no of user who has viewed that add in HBO only or STAR only.

      I should not get the no of user who viewed it in multiple channel.

       

      There are hundred no of channel registered for the subscriber with millions of user.