Page 1 of 1

Data Transformation with average excluding zero

Posted: Wed Sep 13, 2023 3:45 pm
by AJJ
Hi,
I have a data transformation that performs an average calculation, however the average is diluted by there being lots of zeroes in the data (I can't hide or filter the zeroes because there are several averages we want to display). How can I exclude the zeroes in this average calculation?

Thank you.

Re: Data Transformation with average excluding zero

Posted: Wed Sep 13, 2023 10:53 pm
by Lech Kulikowski
Hello,

You can add the custom filter to exclude zeros values.

Thank you.

Re: Data Transformation with average excluding zero

Posted: Thu Sep 14, 2023 8:40 am
by AJJ
This worked really well, thank you.

Re: Data Transformation with average excluding zero

Posted: Fri Sep 15, 2023 10:02 am
by Lech Kulikowski
Hello,

You are welcome.