This content has been marked as final.
Show 4 replies
-
Re: Average without zero values
Andrey Khoronenko Jul 24, 2017 6:18 AM (in response to Michael Ostrovsky)Hi,
Which flag in data of workers who have't committed any transaction at all. May be fragment of source data and waiting result?
Regards,
Andrey
-
Re: Average without zero values
Justin Dallas Jul 24, 2017 9:37 AM (in response to Michael Ostrovsky)Hello Mike,
I tried to get you a solution, but I couldn't figure one out. Somewhere in this statement, probably in the Count clause, you have to have
IF(Aggr(Sum(TransactionCount), WorkerId) > 0)
But I'm not sure if that's the correct statement and where it should go off the top of my head.
-
Re: Average without zero values
Tim Kendrick Jul 24, 2017 10:35 AM (in response to Michael Ostrovsky)Have you tried set analysis? Something like:
COUNT({<[Transactions]-={"0"}>} [Transactions]) / COUNT({<[Transactions]-={"0"}>} DISTINCT [Worker])
or
IF([Transactions]>0,COUNT([Transactions]) / COUNT(DISTINCT [Worker]))
-
Re: Average without zero values
Michael Ostrovsky Jul 25, 2017 9:41 AM (in response to Tim Kendrick )Thank you!
It's really helpful!!
-