Calculate averages of a variable but only using positive data

[Jenny_J]

Hi, 

Just wanted to ask how to get the average value of variables using only positive values.

Thanks.

[Nuraisyah Rosli]

Hi Jenny,

First, you can create condition for positive values only using Value Search tool. It will generate capsules for samples with value greater than 0.

Next you can use Signal from Condition tool to find the average values during this positive value condition.

 

Let me know if this answers your question. Alternatively, you can also sign up for Office Hour session where you can discuss with our Analytics Engineer directly 🙂

 

Edited May 15, 2023 by Nuraisyah Rosli

[Nuraisyah Rosli]

Now that I read your question again, I think you can also use this method, if you already have condition you want to use for you average calculation.

After Step 1 above, you can use within function to create new signal that have positive values only.

Next, you can continue with Step 2 above, but this time change the signal to new signal from formula above (in my case here the name is Positive signals), and condition to the specific condition that you already have (in my case is Hourly condition).

 

Hope it helps!