Forum Discussion
How To Create Measures Over Hours
Hi Anonymous
Here is your file updated based on 34hr averages only at end of each day https://www.dropbox.com/t/XvUdc0zpksXlL9t8
Your report looks like this
Once you start having values that generate averages above 4 then "Blank" card will start showing numbers.
Please let me know if you are now fully satisfied. Thank you.
Hello tamerj1
Thank you for your effort. I will try to explain it more clearly. Now, we already have the 24 moving averages. that is, we have hours ranging from 00 to 23. The 24 moving average occurs at 23 hour. So, I want to count only those values that are associated with 23 hours and check if they exceeded 4 or not. If they don't exceed 4, then the count returns 0. I hope it makes sense now. Thank you tamerj1 !
Hello Anonymous ,
The moving average calculates the the average of the last 24 readings. This happens at the each point starting from the 23rd point onwards as per the table. I think we both agree on this.
Also lets clear the missing decimal point in the readings. The 34 in my report is 3.4 in yours. Having said that, we should also agree that as per the given sample of data the maximum moving average is 3.5
The measure "Above 34" counts the number of moving averages that exceed 34 (3.4) within 24 hours (1day)
- In Jan. 1st we don't have any moving average as the calculatioon starts after 24 hours.
- In Jan. 2nd we have 24 moving averages 8 of them exceed 3.4
- In Jan. 3rd we have 24 moving averages 12 of them exceed 3.4
- After that none of moving averages exceed 3.4 therfore the count is zero (Blank)
What is missing here please help me clarify it up.