We've developed a web-based database and reporting solution for a factory (let's assume they manufacture widgets). They capture data routinely every hour as and when their widgets are completed.
Management receives daily email reports with PDF graphs that summarise the previous day's output. They can also log in to the system at any time and generate custom reports on the fly.
Now management would like to display a couple of simple graphs on the factory floor using big LCD screens, so as to keep factory workers informed, motivated, etc.
The hurdle we're faced with is that there are two shifts working in parallel, each with 14 separate machines, resulting in a lot of data / detailed graphing requirements. Sticking all of this information on one big graph makes it illegible / difficult to interpret.
Thus our idea is to program a summary graph that supports drill-down functionality via minimal interaction. But then we're faced with the question of what is most practical way to allow factory floor workers to interact with these big LCD screens?
Please note that the best solution should also cater for the fact that these LCD screens - 3 of them in total, each 30 metres apart - will require internet connectivity (there is wireless internet within reach).
On a side note, we did consider touch screens, but the workers' fingers get very greasy during the course of their work. We also considered the option of programming the reports to automatically scroll through each graph, but 2 shifts with 14 graphs each... well you get the idea.