Jump to content

Calculate averages of a variable but only using positive data

Recommended Posts

  • Seeq Team

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 by Nuraisyah Rosli
Link to comment
Share on other sites

  • Seeq Team

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!


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...