Forum Discussion
Rate of Inventory Use
Hi All,
I am struggling a bit with figurinout the best approach to this data set attached
The goal is to answer the ff questions. Specifically how fast the inventory is going down/depleted
1. What is the rate of use for N95 masks by the type of stations or which stations are using the N95 masks faster??
2. Are ther partivular stations that are using the inventories faster than others? if so whats their use rate.
Any ideas about how to do this are welcome.
Many thanks in advance.
5 Replies
- HotChilli
Community Champion
Rates of change can be shown by the gradient when plotting one value against another so you could use the line chart. Put date on the axis, sum of N95 in the values and station in the legend. The slope of the line will show which station is using items faster.
You should probably create a date table and relate it your data table (allowing you to slice and dice by any date period you want)
HotChilli Many thanks for your response. I was hoping to have percentages to show the changes as well and then perhaps plot on a chart that shows the stations depleting their inventory stocks quickly. I tried that line chart but not quite what I wish to show: Forexample I want to show station 1 using the N95 masks with daily or weekly downward trend compared with another station.
Hope that clears the air.
Thanks
- HotChilli
Difficult to recommend anything based on the info provided.
I've just dummied up some data to illustrate my suggestion. It shows one station's rate v. another.
If you post some data (not a picture), define your metrics (e.g. 'percentages to show the changes as well') and give your desired outcome I'll see if I can help.
