preview
We're still working on this feature, but we'd love for you to try it out!
This feature is currently provided as part of a preview program pursuant to our pre-release policies.
NRQL Predictions in New Relic uses historical data to predict future trends, providing insights into how metrics might behave in the future. This proactive approach helps you visualize trends and anticipate potential issues, enabling timely interventions to maintain optimal system performance. While NRQL Predictions itself does not identify potential issues, it equips you with the information needed to assess trends and plan for future challenges.
For automatic identification of potential issues, you can enroll for the Predictive Alerts feature, currently available in public preview. Predictive Alerts work alongside NRQL Predictions to automatically trigger alerts when projected trends indicate a potential issue, allowing for proactive management of your systems.
Tip
New Relic currently uses the Holt-Winters model for predicting, which supports hourly, daily, and weekly seasonal patterns and trends in your data.
Pricing
Your use of NRQL Predictions is billable during preview in accordance with your Order as applicable to the pricing model associated with your Account. New Relic Query Language queries (NRQLS) related to use of this feature are billable as the Core Compute Product. If this feature becomes generally available, your use will be billable in accordance with your Order.
For further details on pricing, please contact our sales team or refer to your Order.
Enrollment
To enroll for the NRQL Predictions feature, navigate to one.newrelic.com > Administration > Preview & Trials, and enable NRQL predictions.
Add prediction on a line or area chart
To add prediction on a line or area chart, follow these steps:
Access a line or area chart
- Go to one.newrelic.com > All capabilities.
- To add prediction to a line or area chart, select it from Dashboards, or open it from Metrics and events.
Add prediction
To add prediction, from the menu, select Predict trend. In Data Explorer, the prediction trend appears on the chart, projecting future trends. The prediction range is automatically set to 20% of the query window, and highlighted in gray. The graph appears in dotted lines within the predicted range.
The PREDICT
keyword is appended to the chart query. You can refine the query according to your requirements and run it to get the updated trend.
Tip
When you add prediction to an area chart, the chart type changes to a line chart with prediction.
Add to dashboard
To add the chart with prediction to a dashboard, click Add to dashboard.
Enter a widget name.
Select a dashboard in which you want to add the widget, or create a new dashboard for it.
You can now view the chart with prediction on the selected dashboard.
Default prediction range
When you add a prediction to a chart, the PREDICT
function appends to the existing chart query with the following default behaviors.
- Prediction range: Projects 20% of the total time specified in your query window, allowing you to see a short-term projection based on current trends.
- Historical data: Processes historical data from the current query window and the two preceding ones to generate predictions.
- Time interval: Matches the data point interval of the prediction on the query window, ensuring consistency in data projection.
Example:
FROM Transaction SELECT count(*) WHERE error IS TRUE TIMESERIES PREDICT
The default prediction on the chart appears as follows:

one.newrelic.com > All capabilities > dashboards: default prediction.
Customize the prediction range
You can customize the prediction in the following ways. To get familiar with NRQL, refer to NRQL documentation.
Example:
FROM Transaction SELECT count(*) WHERE error IS TRUE TIMESERIES PREDICT holtwinters(beta: 0.5) BY 3 hours USING 1 day
The customized prediction on the chart appears as follows:

one.newrelic.com > All capabilities > dashboards: customized prediction.