Count of users according to Time

[shanky1907]

Hello,

I have one requirement where i need to show Count of users with 80-100 hours of Time Duration in a month. The filed is calculated on a day to day basis. and Come as TimeDuration.

When one whole month is selected. Then in expression the below expression doesn't work:

=If(sum(TimeDuration)>288000 AND sum(TimeDuration)<=360000,
num(count({<TimeDuration={">288000<=360000"}>}distinct UserId),'#,##0'),'-')

Because in the set modifier the sum(TimeDuration) doesn't work. Can you please suggest an approach

[sunny_talwar · Accepted solution]

@shanky1907 try this

Num(Count({<UserId = {"=Sum(TimeDuration) > 288000 and Sum(TimeDuration)<= 360000"}>}DISTINCT UserId), '#,##0')

[shanky1907]

Fantastic as always.

[sunny_talwar]

Hahaha thanks, glad I was able to help @shanky1907