Hi, I want to build a Weekly Metrics Query that summarizes a Drivers performance based in various Metrics.
All the data is being recorded into a MetricsDetails table with the following fields;
Record_Date, Record_ID Driver_ID, Metric_ID, Flag_ID, PointsEarned
I have made a Query that is calculating the WeekNumber and WeekDay.
Any suggestions which route to take?