Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Have a look at the attached application.
Regards,
Kaushik Solanki
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
Does anybody have any idea?