Determine the number of groups without profit

[schuffe]

Hello

I prepared some Data to explain my problem:

My Goal is to make a KPI, that tells me how many groups didnt made profit (consider each day individually) and I want to analyse a period of time (e.g. 01.01.2020 - 31.01.2020).

In my Example the KPI would tell me 4 (B,E on 01.01.2020 and B,D on 02.01.2020).  

Thanks in advance.

[lironbaram · Accepted solution]

HI 
sum(aggr(if(sum(Profit)>0,0,1),Group,Date))
should give you the results you want

[schuffe]

Thank You, thats perfect 👍