Set analysis

[zied_ahmed1]

Hello,

I have this KPI :

Count(doc)

and i need to this condition to have just the number of docs who have values >30  :

if(num(num#(interval(Field2-Field1,'mm'),'###'))>30)

how to do this with set analysis

Thanks

[sunny_talwar · Accepted solution]

How about this

Count(DISTINCT {<doc = {"=Num#(Interval(Field2 - Field1, 'mm'),'###') >30"}>} doc)