Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello..
We are facing a problem that we don't know how to solve.
We have user data, and some timestamp that the user has interact. there is a from and to date for each product, and them we have a months table with user and dates.
We need to count, how many user has data between the dates in that user data date (see table months).
We try several expressions, but we didn´t achieve a thing.
Thanks.
Hi Gonzalo,
Please check attached
Hope that helps.
You can also try
Count(DISTINCT YYYYMM_JOINED)
Probably I express myself bad (or I explained it bad)...
What I want to know, is according From and to, the user is for every YYYYMM between that period, so it should only tell me true or false for each pair user-YYYYMM and after that, count the number of TRUE ocurrences..
Thanks for the help!