I wonder how can I filter out entries from the loaded data. From my data I want to discriminate all users that have count of distinct dates > 2. So In this case I want to drop all information from U1 and in *all* the reports work only with U2 and U3
Another question: I do not understand how the inner join changes if you do not require an aggr function. Lets say I just want the entries where date betweeen x and y.
I don't understand your question. Regarding Aggr please be aware that this function is not available in script. It is a UI function that creates an in-memory array like a straight table with one expression and one or more dimensions.
When you talk of date between x and y then you should add a where condition when loading your data like
WHERE Date >= x AND Date <=y.
If you want to consider users whose number of distinct dates lie between two values then
Actually what I want to try is to filter by date WHERE Date >= '2017-08-11' AND Date <='2017-08-13' but filter out all the entries of the user´s that don´t fulfill the condition. In this case, U1 has a good entry but it should be discriminated and return only the records for U2 and U3. I was thinking something like calculating the Min and Max Dates for each User, but my example based in your previous answer doesnt work. Any suggestions?
I tried with:
Inner Join (Data)
LOAD
User, Date
WHERE MinD > '2017-09-01' and maxD < '2017-09-05';
LOAD User, Datum, min(date(Date)) as MinD, max(Date) as MaxD
