You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Managing the sensitivity of colour gradation in Heat maps

Received Response
27
Views
1
Comments
edited Mar 28, 2019 5:46AM in Supply Chain Planning and Collaboration 1 comment

Summary

Heat maps don't provide a way to natively control the scale of colour gradation and Heat Map sensitivity, this method provides one option

Content

I use the forecast error MAPE in a Heat Map to identify items for review. An outlier in the end-of-month data for one period resulted in a MAPE being generated for an item of 27000, which meant every other item didn't register as significant on the Heat Map scale. I couldn't find a way to control the scale of the Heat Map, but it occurred to me I could create a new measure that used an IF statement to limit the value of the MAPE (in my case to 50). By modifying the limited value, I could in turn control

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!