New Relic's 1-hour raw aggregation limit on timestamps prevents us from accurately tracking metrics like "Time To First API Design" and "Time To Fix a Validation Error" over a 3-month period.
1)The query will round older data, leading to inaccurate results for these metrics.
2) We can't use the TIMESERIES feature to request historical data.
Possible Solutions
Extend the query time: Using the RAW query modifier to access unaggregated data for up to 2 days.
Implement Local Caching: Implement a local caching system to store data for these specific metrics for 3 months.
Problem
New Relic's 1-hour raw aggregation limit on timestamps prevents us from accurately tracking metrics like "Time To First API Design" and "Time To Fix a Validation Error" over a 3-month period.
1)The query will round older data, leading to inaccurate results for these metrics. 2) We can't use the TIMESERIES feature to request historical data.
Possible Solutions
RAWquery modifier to access unaggregated data for up to 2 days.