Showing results for 
Search instead for 
Did you mean: 

Head's Up! Site migration is underway. Phase 2: migrate recent content

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

All the sessions of the conference are now available online