Count Days Based on Conditions

[#1]

HI

Please find attached the data .

And the output based on data is as given below.

StaffName	Avg Distinct Message per Day	Number of days with Distinct Message  > 500	Max Distinct Message procesed in a day	Min Distinct Message procesed in a day
ABC	455	4	715	1

[settu_periasamy]

Hi Senthil,

Have you tried something?

you can achieve this using the aggregation. 

PFA for reference.

[sunny_talwar]

Here you go: PFA

Exp1: =Avg(Aggr(Count(Message), Date))

Exp2: =Count(If(Aggr(Count(Message), Date)>500, Date))

Exp3: =Max(Aggr(Count(Message), Date))

Exp4: =Min(Aggr(Count(Message), Date))

Best,

Sunny