Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
HotChilli
Community Champion
6 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HotChilli  I am trying to insert an excel file version but I dont have that option. Is it possible to recreate it with the picture?? I will explore other ways to share the file.

     

    Thanks