Thank you Sunil!
But I do not understand your syntax.
Did you mean like this?
Load
Time,
Client_ID,
if(sum(Happy_client)>0,1) as Good_time,Good time Good timeGood time
from path
group by Time ,Client_ID;
Sounds good, but I would like to use no "if", because this makes everything very slow. So I use an "OR".
1-product(1-Happy_client)
But how is the function for Products called?
