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.
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Rolling Aggregation | 1 | 758 | May 13, 2019 | |
Is there an Average Duration? If not can we put a request in for such a concept? | 2 | 819 | August 14, 2019 | |
Using dates best practice | 2 | 199 | April 2, 2024 | |
Finding data from a set time frame | 4 | 461 | August 25, 2020 | |
Computing Duration from dates for a list | 8 | 768 | May 18, 2019 |