APAC SD Team
NA Business Team
Category
Data Sources
Product Version
7.4
Moving Average not working properly
Defect Fixed
Hi team
I'm trying to create a 10 week moving average graph of our bought and used. The data is as below
The 10 week moving averages that Yellowfin is calculating are not correct.
The issues are
1. It does not allow to skip the first 9, so first 9 averages aren't based on 10 records anyway.
2. The 10th record should be an average of previous 10 records i.e.
14/08/2016, 34844.00, 25022.00
Whereas yellowfin shows it as
14/08/2016, 28177.00, 39,254.00
I have double checked things through attached excel as well, but the averages are way off actual values.
Can someone suggest what could be going wrong here?
Kind Regards
Usman Jamil
Files:
Data.xlsx
The same problem 
Hi Usman,
It looks like Yellowfin is not including the current value in the calculation, and is instead counting the previous X moving average:
I have raised this as a defect and will update this ticket when action is taken.
Please let me know if you have any questions in the meantime.
Regards,
Nathan
Hi Usman,
It looks like Yellowfin is not including the current value in the calculation, and is instead counting the previous X moving average:
I have raised this as a defect and will update this ticket when action is taken.
Please let me know if you have any questions in the meantime.
Regards,
Nathan
Hi Nathan
I guess I attached incorrect snapshot, this is what I should have attached but thanks for setting it up at your end and pointing out the defect.
I see that 10 WMA are being calculated correctly but not being linked to correct date.
Further to this, Is there any way to skip the first 9 records since it shows a huge and incorrect spike when graphed?
Usman Jamil | Development Manager
(+613 8622 8506 : |*usmanj@sacsconsult.com.au
www.sacsconsult.com.au
Have you read this week’s SACS blog?
Follow SACS
From: Yellowfin Support <support@yellowfin.bi>
Sent: Wednesday, June 6, 2018 2:42 AM
To: Usman Jamil <usmanj@sacsconsult.com.au>
Subject: New Comment in "Moving Average not working properly"
Hi Nathan
I guess I attached incorrect snapshot, this is what I should have attached but thanks for setting it up at your end and pointing out the defect.
I see that 10 WMA are being calculated correctly but not being linked to correct date.
Further to this, Is there any way to skip the first 9 records since it shows a huge and incorrect spike when graphed?
Usman Jamil | Development Manager
(+613 8622 8506 : |*usmanj@sacsconsult.com.au
www.sacsconsult.com.au
Have you read this week’s SACS blog?
Follow SACS
From: Yellowfin Support <support@yellowfin.bi>
Sent: Wednesday, June 6, 2018 2:42 AM
To: Usman Jamil <usmanj@sacsconsult.com.au>
Subject: New Comment in "Moving Average not working properly"
Hi Usman,
Currently there is no way to adjust this function other than to create your own. If this is an urgent issue it may be possible to provide you with a basic example of that. If not, you will need to wait for an official fix on both of these (I will include the null gap into the defect ticket).
Nathan
Hi Usman,
Currently there is no way to adjust this function other than to create your own. If this is an urgent issue it may be possible to provide you with a basic example of that. If not, you will need to wait for an official fix on both of these (I will include the null gap into the defect ticket).
Nathan
Hi Usman,
Try the attached file. Load it through the plugin manager and it will appear as Moving Average (Corrected)
Nathan
Hi Usman,
Try the attached file. Load it through the plugin manager and it will appear as Moving Average (Corrected)
Nathan
Hi,
Nathan, has there been any movement with this defect request?
Alternatively, would the fix you supplied above work with 7.2? We are trying to get this client upgraded but in the meantime this is what we're working with.
Also to confirm the plugin will calculate the moving average from the current month back, not the last month back.
Regards,
Peter
Hi,
Nathan, has there been any movement with this defect request?
Alternatively, would the fix you supplied above work with 7.2? We are trying to get this client upgraded but in the meantime this is what we're working with.
Also to confirm the plugin will calculate the moving average from the current month back, not the last month back.
Regards,
Peter
Hi Simon,
OK, thank you for the update.
Would this solution be OK to use should we proceed with the client upgrade (to v9.5) as planned in the near future?
Regards,Peter
Hi Simon,
OK, thank you for the update.
Would this solution be OK to use should we proceed with the client upgrade (to v9.5) as planned in the near future?
Regards,Peter
Replies have been locked on this page!