Graphite

Graphing movingAverage for only existing (not None\Null) data

Asked by bart

Let's say I have the following metric:

http://i.imgur.com/Ssn3FVM.png

PRO2.streambase.travelport-hotel.all.jiniIn.HotelInventoryService.reclaimInventory.pctFailed

I would like to create a graph to show the moving average calculated from only last five existing values. Unfortunately, the function such as this one:

movingAverage(PRO2.streambase.travelport-hotel.all.jiniIn.HotelInventoryService.reclaimInventory.pctFailed,5)

is taking into account the Null, or None values, and not producing movingAverage for the visible data:

http://i.imgur.com/bC8Ibhw.png

I would like to see the moving average for ONLY the X last reported data points (therefore, visible, not Null, or None, datapoints. On the graph above, those would be the visible 100's and 0's).

Can this be achieved in Graphite? If so, what function could be used?

Greetings from OWW!

Question information

Language:
English Edit question
Status:
Answered
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Jason Dixon (jason-dixongroup) said : 		#1

You could use a combination of transformNull() to convert your Nulls to a value (e.g. -1) which could then be filtered out more easily using removeBelowValue().

Jason

Can you help with this problem?

Provide an answer of your own, or ask bart for more information if necessary.

To post a message you must log in.