need advice on what to do about statistics or graphs and charts or both
Posted on 2009-04-07
heres the situation....
for a vehicle mechanic shop there are different sections of people. engine people, tire people, ect.. each section has its own list of job tasks. using the db im working on i need a form and/or report to show status. status for each shop and overall. example... tire section has say 10 job tasks, so thats my total or 100% and lets say they have 6 tasks done and 4 still open so 60% complete. that type of thing.
i will probably be asked sometime to have this info available for supervisors.
i already have a report for listing all open jobs per section, kinda like a hard copy list to go by for workers. i also already have a report for tasks that are finished. but i just know that the higher supervisors are gonna want visuals, charts, graphs, statistics.
so i guess the question is whats the best way to do these things? reports? maybe like a dashboard type form? anybody?