Showing results for 
Search instead for 
Did you mean: 

Rolling averages by date


I am trying to return rolling averages for a metric, for a variety of date ranges. For example, I am trying to calculate the rolling average for 7 days, 30, 60, and 90 days. Before I calculate I want to groupby a name column then calculate. I want the start date to be the earliest instance on what date that name first appears. My company is transferring a lot of our feature calculation for ml into graph and the data is sensitive so I cannot share. We have metric node property, as property, and name property of node that [:HASMETRIC] ->(d:Day). Schema kinda like this.

Nodes 2022
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.