3 Replies Latest reply: Aug 1, 2013 4:07 AM by ali metin RSS

    count distinct user_id on bar chart

      Hi,

       

      I have like following data:

       

      User_ID      xDate

       

      A                01.07.2010

      A                01.07.2011

      A                01.07.2012

      B                02.08.2009

      B                02.08.2010

       

      year(today()) - year(min((xDate)) = year(yDate)

       

      I am trying to create a Bar chart which counts distinct the User_ID per year(yDate) .

       

      I must count the user A only on 3. bar (2013 - 2010 = 3)  and the user B only on 4.bar (2013 - 2009 = 4)

       

      please help its important..

      thank you