cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

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, day.name as property, and name property of node that [:HASMETRIC] ->(d:Day). Schema kinda like this.

0 REPLIES 0
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online