PLANIQ - How to import the Metrics like MAPE/MASE etc from the planiq to Anaplan

JagadeshNarayanan

Hi all,

I am working on PlanIQ and managed to get data from the PlanIQ to Anaplan using different algorithms.

now to decide which algorithm is efficient I need the metrics to be imported from the PlanIQ to Anaplan.

So please help me in getting the metrics(MAPE/MASE,etc..).

Thanks

Jagadesh.S

Accepted answers

All comments

Misbah

@JagadeshNarayanan

I don't think we can do that yet!

You can post this idea on idea exchange forum with your use case

Misbah

Miz Logix

JagadeshNarayanan

Hi Misbah,

Thanks for your reply.

when I checked a demo from Bedford Consulting in you Tube Link: https://www.youtube.com/watch?v=EyDvzhq4qqg&t=622s

They are showing all the parameters shown in the image below

so they are getting these parameters from the planIQ and based on that they are deciding the best algorithm for every forecast action schedule iteration.

Can you please take a look is it imported manually or imported directly from PlanIQ

Thanks

Jagadesh.S

Misbah

@JagadeshNarayanan

Well, I am not sure if it is being imported from PLAN IQ or calculated within Anaplan once PLAN IQ results are out. Let me tag one of the best @timothybrennan .

Misbah

Miz Logix

timothybrennan

Hi @JagadeshNarayanan ,

Importing the metrics that are displayed on the right hand panel of PlanIQ is currently not an available feature.

The approach I encourage most users to take is to calculate the relevant forecast evaluation metrics directly in Anaplan. Once you have forecast results from PlanIQ, if you have actuals available for the period you were forecasting or imported your backtest results, you have all the information you need.

Additionally, the metrics displayed in the PlanIQ interface don't offer much value, as they are simply averages of metrics across the entire data set. We're working to correct this in the future. By calculating the metrics directly in Anaplan you can correctly determine which particular algorithm has been the most accurate at predicting each individual time series in the data set (which is likely your desired outcome).

I've attached images of a very simple way to calculate the evaluation metrics that I think are usually most appropriate in doing this type of analysis.

MAE = Mean Absolute Error

MAPE = Mean Absolute Percent Error

sMAPE = Symmetric Mean Absolute Percent Error

RMSE = Root Mean Squared Error

Please let me know if there is any other information that would be helpful for you!

Thanks for the tag @Misbah

Simple_Eval_View_127938.png

Simple_Eval_BluePrint_127938.png

JagadeshNarayanan

Hi @timothybrennan ,

Thanks for your reply. This will solve my problem.

The screen shot you provided for the calculation is very awesome and helpful.

I will try this approach for calculating the different metrics to find the best algorithm.

Thanks a lot for your help and information

Jagadesh.S

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…