Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
PFA
Hi,
You just calculated the daily unique customer count. I want to calculate a time range of 365 for each day.
Hi,
Give one sample for better understanding of your requirement