This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Determine column mean by day and within certain hours
Aug 14, 2012 06:35 PM(9033 views)
Hi Folks,
I have some hourly data and I'm trying to calculate the mean of variable x for each Day when Hour >= 1 and <=10. I need to store this computed value in column y for each hour of each day. I have tried Column Mean by Day where I've excluded all hours that fall outside 1 & 10, but Column Mean calculates the value for all data by Day regardless of what's been excluded. Any suggestions on how to accomplish this using either a formula for column y or in JSL would be greatly appreciated. Thanks