G
Guest
Looking for some guidance on setting up a database for performing some metric
calculations.
This data consists of the following:
LTL Orders
TL Orders
Parcel Orders
LTLLines
TL Lines
Parcel Lines
LTL Peices
TL Peices
Parcel Peices
This data is collected for today's date. yeasterdays date (past due), and
All the rest of the past due after yeasterdays date.
The above data is collected each day.
The second set of collected is Hours.
Hours are broken up by 3 shifts Total Labor hours for each task. (About 14
tasks.)
I need to then do calculation on the 2 types of data and end up with s report.
The question is does anyone have a suggestion on how to normalize tables for
this?
calculations.
This data consists of the following:
LTL Orders
TL Orders
Parcel Orders
LTLLines
TL Lines
Parcel Lines
LTL Peices
TL Peices
Parcel Peices
This data is collected for today's date. yeasterdays date (past due), and
All the rest of the past due after yeasterdays date.
The above data is collected each day.
The second set of collected is Hours.
Hours are broken up by 3 shifts Total Labor hours for each task. (About 14
tasks.)
I need to then do calculation on the 2 types of data and end up with s report.
The question is does anyone have a suggestion on how to normalize tables for
this?