5 Replies Latest reply: Jan 1, 2018 7:40 PM by jennifer Gan RSS

    Cant get correct count at aggr level

    jennifer Gan

      Hi

      This is my data set

         

      ChannelBUMonthQty
      webCI11
      webCI12
      webDB13
      webDB14
      webDB15
      webDB16
      webDB19
      webDB24
      webDB22
      webDB21
      webCI29
      webCI28
      webCI27

       

      I wanted to get the last col to be a distinct count for the month. which would be 7 for JAN and 6 for FEB.

      But you can see from the results I only get 7 for the 1st row, and 6 for the last row.

      Not understanding why it is blank for the 2 middle rows.

       

      Can you help to explain what I should do? and why is my logic wrong? Appreciate your inputs.

         

      ChannelBUMonthCount(DISTINCT Qty)aggr((Count(  Distinct Qty)) ,Month)
      9-
      webCI127

      web

      DB

      1

      5

      -

      web

      CI

      2

      3

      -

      web

      DB

      2

      3

      6

       

       

      The effect I wanted is

         

      ChannelBUMonthCount(DISTINCT Qty)aggr((Count(  Distinct Qty)) ,Month)
      9-
      webCI127
      webDB157
      webCI236
      webDB236