Hi guys, I'm working on a data display method to help out my mothers work place, and I am basically trying my best to figure out how to display the info I've been given.
The goal here is to try and figure out some very basic trends for stock consumption and the best way to replenish. The info I have is as follows:
A list of item names
A months worth of information separated into days and the below.
The morning stock level after the daily pre-opening delivery
The after lunch stock level
The evening stock level
I need some way to overlay the stock level of Item A and its daily progress, versus every week of data I have, plus do the same for every day of the week. This way it could show if certain days are better or not. The problem is this would mean a seperate graph per stock item, and theres a lot, so overlaying 4 weeks worth of data for each item would create a mess soon. Not doing it this way means a seperate graph for every item, which is a lot of printing and not good at a glance.
I was considering instead using a running average for the item so therefore combining the set days into one line, ie (tuesday week 1 + tuesday week 2) /weeks. But that wouldnt take into account week by week fluctuations.
Heres hoping for some great ideas!
Thanks in advance
The goal here is to try and figure out some very basic trends for stock consumption and the best way to replenish. The info I have is as follows:
A list of item names
A months worth of information separated into days and the below.
The morning stock level after the daily pre-opening delivery
The after lunch stock level
The evening stock level
I need some way to overlay the stock level of Item A and its daily progress, versus every week of data I have, plus do the same for every day of the week. This way it could show if certain days are better or not. The problem is this would mean a seperate graph per stock item, and theres a lot, so overlaying 4 weeks worth of data for each item would create a mess soon. Not doing it this way means a seperate graph for every item, which is a lot of printing and not good at a glance.
I was considering instead using a running average for the item so therefore combining the set days into one line, ie (tuesday week 1 + tuesday week 2) /weeks. But that wouldnt take into account week by week fluctuations.
Heres hoping for some great ideas!
Thanks in advance