I’d like to use Insights to monitor our Microsoft Azure auto-scaling rules, and I’ve written a tool that creates a custom Insights event whenever one of our Azure webapps scales up or down.
I’m trying to use NRQL to plot a timeseries graph with the number of instances a particular webapp is using over time. The data looks roughly like this:
timestamp appName newInstanceCount scaleDirection
00:10 site1 2 ScaleUp
00:15 site2 4 ScaleDown
04:00 site1 3 ScaleUp
05:00 site1 2 ScaleDown
I’m using a NRQL query like SELECT max(newInstanceCount) FROM AutoScaleAction SINCE 1 DAY AGO WHERE appName = 'site1' TIMESERIES AUTO
to render a line chart with the value of newInstanceCount
over time.
The problem I’m running into is that when using TIMESERIES, periods during which there is no data are rendered as zero on the graph. Since I only insert an event when the value of newInstanceCount
changes, the line drops to zero between 00:10 and 04:00. I’d like the line chart to display the last-known value for periods where there is no data, rather than zero.
I’ve looked at the NRQL reference but I can’t seem to figure out a way to graph the data the way I want – Is this sort of scenario supported? What am I doing wrong here?
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
0 voters
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.