Simple moving average using Rapid Miner

naeyam

I have the following data. The count field is calculated based on the method, status and date (I would also have the host name in the future). Can you please tell me how to calculate simple moving average based on HTTP method, date, and status? Please point to me tutorials on Ramid Miner.


HTTP Method    Date          Status      Count
GET            1st July      200          10
GET            2nd July      200          20
GET            3rd July      200          15
GET            4th July      200          8
GET            5th July      200          50
GET            1st July      500          15
GET            2nd July      500          85
GET            3rd July      500          55
GET            4th July      500          10
GET            5th July      500          10
POST            1st July      301          15
POST            2nd July      301          15
POST            3rd July      301          85
POST            4th July      301          15
POST            5th July      301          15

Thanks in advance,
Labora.

DocMusher

Hi,
Please take a look at: https://www.youtube.com/watch?v=w0vSSEq2bn0

naeyam

Thanks, I looked at the video. I don't see the moving average in Rapid Miner 6.4. Googling to find our MA in 6.4.

MartinLiebig

Hey,

Moving Average is part of the time series extension.

Cheers
Martin