AnsweredAssumed Answered

30 day rolling average ... Best way?

Question asked by teachcalds on Oct 19, 2018
Latest reply on Oct 19, 2018 by teachcalds

Asking for the best way to accomplish this. Here's what we are doing. We have a survey that is used twice daily for water calculations. The field personnel would like to see a 30 day rolling average of what has been collected. Also if no collection is done we need to know that it's actually a null value day. Example: So if we collected Sunday through Wednesday, skipped Thursday, and collected for the next 26 days you'd actually have 30 out of 31 days of collection. But since we did not collect on that Thursday, the first day I mentioned in the example (Sunday) would be outside of the 30 day rolling calculation, so it wouldn't be included. But now we have 29 out of 30 (Monday through Wednesday, a skipped Thursday, and 26 days straight starting on that Friday). So the final calculation for our 30 day rolling average would need to readjust itself to take everything, add it together, and divide by 29 and not 30 when skips happen. Most of the time it will be nonstop. That's what they're supposed to do, but I want that safeguard just in case there is the chance of a day being skipped. Would anyone at Esri know how to accomplish this? The most important part is how to track a 30 day rolling average on Survey123 collected data. Is Operations Dashboard the only viable option?


#30 Day #Rolling Average