Set Analysis - Calculating Cumulative Unique User Count

[#1]

Hello,

I have the following table,

Order Date,

OrderId

UserId

I would like to see in a table for each day, number of distinct users ordered for the last 365 days.

i.e.

for 01.01.2013 - count of distinct users ordered between 01.01.2012 and 01.01.2013

for 02.01.2013 - count of distinct users ordered between 02.01.2012 and 02.01.2013

and so on.

so i need a table with daily based date dimension and an expression with count of distinct users.

Thanks in advance.

[#2]

Hi,

PFA

[#3]

Hi,

You just calculated the daily unique customer count. I want to calculate a time range of 365 for each day.

[#4]

Hi,

     Give one sample for better understanding of your requirement