cancel
Showing results for 
Search instead for 
Did you mean: 

Rolling averages by date

amoss038
Node

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

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