count distinct user_id on bar chart

[#1]

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

[kaushiknsolanki]

Hi,

     Have a look at the attached application.

Regards,

Kaushik Solanki

[#3]

Hi,

Dimension must be per year and in expr. must be counted User_Id. 

But I can not write in dimension min() function ( Year(Today()) - Year(min(xDate)) )  and it works wrong.

I must count Users in every min date only once. Also user A only on 3 bar not others.

see attached file.

thanks

[#4]

Does anybody have any idea?