########################################################################################## VEH-18: Driver mileage chart ########################################################################################## Issue Type: New Feature ----------------------------------------------------------------------------------------- Issue Information ==================== Priority: Major Status: Closed Resolution: Done (2013-11-02 18:49:32) Project: VehMan (VEH) Reported By: btasker Assigned To: btasker Components: - Charts Targeted for fix in version: - 1.0.1 Time Estimate: 0 minutes Time Logged: 0 minutes ----------------------------------------------------------------------------------------- Issue Description ================== Sort of an expansion of the average mileage chart, but using all vehicle records to show a driver's monthly mileage spread across all vehicles ----------------------------------------------------------------------------------------- Attachments ============ - D-Driver1-48c1f275089adab3e650b1f05a463dfbd182fe34.png - historic_monthly_mileage.png ----------------------------------------------------------------------------------------- Issue Relations ================ - is blocked by VEH-21: Service Stats Generation - is blocked by VEH-19: Fuel Stats Generation - relates to VCL-2: Add Support for Historic Mileage Chart - relates to VEH-24: Update Charts Documentation ----------------------------------------------------------------------------------------- Subtasks ========== - VEH-24: Update Charts Documentation ----------------------------------------------------------------------------------------- Activity ========== ----------------------------------------------------------------------------------------- 2013-11-02 17:34:38 btasker ----------------------------------------------------------------------------------------- Chart implemented but untested. ----------------------------------------------------------------------------------------- 2013-11-02 17:34:56 ----------------------------------------------------------------------------------------- btasker changed status from 'Open' to 'In Progress' ----------------------------------------------------------------------------------------- 2013-11-02 18:48:08 btasker ----------------------------------------------------------------------------------------- Changed the query to ignore Servicelog entries. Whilst it is a representation of mileage, the petrol log also covers the mileage recorded there leading to some odd results on the chart. Google and pCharts tested ----------------------------------------------------------------------------------------- 2013-11-02 18:49:00 btasker ----------------------------------------------------------------------------------------- PChart created with the test data that's present ----------------------------------------------------------------------------------------- 2013-11-02 18:49:00 ----------------------------------------------------------------------------------------- btasker added 'D-Driver1-48c1f275089adab3e650b1f05a463dfbd182fe34.png' to Attachments ----------------------------------------------------------------------------------------- 2013-11-02 18:49:32 ----------------------------------------------------------------------------------------- btasker changed status from 'In Progress' to 'Resolved' ----------------------------------------------------------------------------------------- 2013-11-02 18:49:32 ----------------------------------------------------------------------------------------- btasker added 'Done' to resolution ----------------------------------------------------------------------------------------- 2013-11-02 19:40:46 btasker ----------------------------------------------------------------------------------------- Google Chart ----------------------------------------------------------------------------------------- 2013-11-02 19:40:46 ----------------------------------------------------------------------------------------- btasker added 'D-Driver1-81b273fec5542e325ccef68b4429cc398082e86a.html' to Attachments ----------------------------------------------------------------------------------------- 2013-11-02 23:53:14 ----------------------------------------------------------------------------------------- btasker removed 'D-Driver1-81b273fec5542e325ccef68b4429cc398082e86a.html' from Attachment ----------------------------------------------------------------------------------------- 2013-11-02 23:53:35 btasker ----------------------------------------------------------------------------------------- Screenshot of Google Chart ----------------------------------------------------------------------------------------- 2013-11-02 23:53:35 ----------------------------------------------------------------------------------------- btasker added 'historic_monthly_mileage.png' to Attachments ----------------------------------------------------------------------------------------- 2013-11-03 00:31:47 ----------------------------------------------------------------------------------------- btasker added '1.0.1' to Fix Version ----------------------------------------------------------------------------------------- 2013-11-10 04:29:47 btasker ----------------------------------------------------------------------------------------- Tested and working. ----------------------------------------------------------------------------------------- 2013-11-10 04:29:56 ----------------------------------------------------------------------------------------- btasker changed status from 'Resolved' to 'Closed'