Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this
Count(DISTINCT {<doc = {"=Num#(Interval(Field2 - Field1, 'mm'),'###') >30"}>} doc)
How about this
Count(DISTINCT {<doc = {"=Num#(Interval(Field2 - Field1, 'mm'),'###') >30"}>} doc)