I would like to visualize the opening and end stock in one line. This means for example
Opening Stock Week 1: 100 (t = 1)
End Stock Week 1: 80 (t = 2)
Opening Stock Week 2: 120. (t = 2)
This means on the x-axis (t = 2) has 2 values 80 and 120. I would like to see this jump without creating dummy x-axis points which are very close to t = 2.
Is this possible?
Best answer by Gertjan
View original
+7
Not sure if it would work for you, but if you create a parameter that is two dimensional:
pStockLevel( iPeriod, iOpeningOrClose )
where the second index is just an index for set with opening and close elements, you could put period and openingclose on the x-axis. However, they will be evenly spaced, not sure if that is what you want
Thanks Guido for your suggestion.
It is not the full solution yet, but this option visualizes the best so far
+6
Hi
Can you share a visual/screen-capture of the result? As we do not have such a stock chart in stock, so curious to see how the suggestion of
Thanks in advance.
This is an visualisaition of the stock graph now…
The dotted straight line is the safety stock
+6
Maybe you can also use the Bar Chart to display the difference per period. If it’s not (like in example) always 1-directional (going down), you could use color coding for each direction.
This is a stacked bar-chart where I made the base transparent (‘Closing Stock’ value in your example) and calculated the difference between ‘Opening’ and ‘Closing’.
Soon we’ll add the line option allowing you to add e.g. a safety stock line.
For bar-line chart, see also: https://community.aimms.com/share-your-product-ideas-37/can-we-have-a-barchart-linechart-in-the-same-chart-311?postid=1912#post1912
Thanks Gertjan, for your suggestion. For now we wait for 4.76 and then decide if we want to move forwards using the combination of the bar and line chart.
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
