D3
OG
Old school D3 from simpler times
All examples
By author
By category
About
empiimp
Full window
Github gist
Opportunity Amount graph // source http://jsbin.com/tarujivagusu
<style id="jsbin-css"> body { font: 12px Arial;} path { stroke: steelblue; stroke-width: 2; fill: none; } .axis path, .axis line { fill: none; stroke: grey; stroke-width: 1; shape-rendering: crispEdges; } .area { fill: tan; stroke: none; stroke-width: 1; } </style> <!DOCTYPE html> <meta charset="utf-8"> <style> </style> <script src="https://d3js.org/d3.v3.min.js"></script> <body> <script id="jsbin-javascript"> // Amounts: Draw the line from the current date to the next date horizontally, then vertically to the new value. // If the close date is in the past, use the close date as the right x axis // If the close date is in the future, use the current date as the right x axis // Go one day past the close date or current date so a line is drawn /* APEX to generate JSON //0064000000QKK5qAAH' 0064000000YMH0VAAX' List<Opportunity> oList = [SELECT Id , AmountLocal_Software__c , AmountLocal_SoftwareHigh__c , AmountLocal_SoftwareLow__c , CloseDate , Forecast_Category_AVP__c , Forecast_Category_ISR__c , Forecast_Category_Manager__c , Forecast_Category_Rep__c , Forecast_Category_VP__c , StageName , CreatedDate , (Select OldValue, NewValue, CreatedDate, Field From Histories where Field IN ('AmountLocal_Software__c' , 'AmountLocal_SoftwareHigh__c' , 'AmountLocal_SoftwareLow__c' , 'CloseDate' , 'Forecast_Category_AVP__c' , 'Forecast_Category_ISR__c' , 'Forecast_Category_Manager__c' , 'Forecast_Category_Rep__c' , 'Forecast_Category_VP__c' , 'StageName') ORDER BY createdDate DESC ) FROM Opportunity WHERE ID = '0064000000QKK5qAAH' LIMIT 1 ]; System.Debug(JSON.serialize(oList)); */ var fields = { AmountLocal_Software__c : 1, AmountLocal_SoftwareHigh__c : 1, AmountLocal_SoftwareLow__c : 1, // CloseDate : 1, // Forecast_Category_AVP__c : 1, // Forecast_Category_ISR__c : 1, // Forecast_Category_Manager__c : 1, // Forecast_Category_Rep__c : 1, // Forecast_Category_VP__c : 1, // StageName : 1 }; var rawdata = [{ "attributes": {"type":"Opportunity","url":"/services/data/v31.0/sobjects/Opportunity/0064000000YMH0VAAX"}, "Histories":{ "totalSize":5, "done":true, "records":[{ "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-10T10:30:11.000+0000", "NewValue":40000, "Id":"017400000Nk3o66AQA", "OldValue":50000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-15T10:30:11.000+0000", "NewValue":30000, "Id":"017400000Nk3o66AQA", "OldValue":40000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-30T10:30:11.000+0000", "NewValue":20000, "Id":"017400000Nk3o66AQA", "OldValue":30000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-10-10T10:30:11.000+0000", "NewValue":15000, "Id":"017400000Nk3o66AQA", "OldValue":20000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-10-12T10:30:11.000+0000", "NewValue":10000, "Id":"017400000Nk3o66AQA", "OldValue":15000, "Field":"AmountLocal_SoftwareHigh__c" } ]}, "StageName":"Due Diligence", "CreatedDate":"2014-08-01T10:30:11.000+0000", "AmountLocal_SoftwareHigh__c":10000.00, "AmountLocal_Software__c":9250.00, "AmountLocal_SoftwareLow__c":1000.00, "Id":"0064000000YMH0VAAX", "CloseDate":"2015-01-30", "Forecast_Category_Rep__c":"Upside" }]; rawdata =[{"attributes":{"type":"Opportunity","url":"/services/data/v31.0/sobjects/Opportunity/0064000000QKK5qAAH"},"Histories":{"totalSize":126,"done":true,"records":[{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000F3VlQeAQK"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-04-08T20:05:53.000+0000","NewValue":"2013-04-30","Id":"017400000F3VlQeAQK","OldValue":"2013-03-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVohdAQD"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:45:20.000+0000","NewValue":"2013-07-31","Id":"017400000FTVohdAQD","OldValue":"2013-04-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVtFQAQ1"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:48:43.000+0000","NewValue":"Qualification","Id":"017400000FTVtFQAQ1","OldValue":"Sales Qualified Lead"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVtTxAQL"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:48:43.000+0000","NewValue":"Most Likely","Id":"017400000FTVtTxAQL","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FdKNw6AQG"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-24T12:29:04.000+0000","NewValue":"Most Likely","Id":"017400000FdKNw6AQG","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FmkcN8AQI"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-04T14:52:57.000+0000","NewValue":"2013-08-15","Id":"017400000FmkcN8AQI","OldValue":"2013-07-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FtAKCNAQ4"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-12T19:51:47.000+0000","NewValue":550000,"Id":"017400000FtAKCNAQ4","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FxmEITAQ2"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-17T22:27:34.000+0000","NewValue":227000,"Id":"017400000FxmEITAQ2","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn01UAQQ"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:42:06.000+0000","NewValue":275000,"Id":"017400000Fxn01UAQQ","OldValue":550000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn01VAQQ"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:42:06.000+0000","NewValue":650000,"Id":"017400000Fxn01VAQQ","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn1pcAQA"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:45:20.000+0000","NewValue":330000,"Id":"017400000Fxn1pcAQA","OldValue":275000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4l4V0AQI"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-26T13:20:57.000+0000","NewValue":"Most Likely","Id":"017400000G4l4V0AQI","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4nyQBAQY"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-27T01:16:53.000+0000","NewValue":"Due Diligence","Id":"017400000G4nyQBAQY","OldValue":"Qualification"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4nyQCAQY"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-27T01:16:53.000+0000","NewValue":"2013-08-30","Id":"017400000G4nyQCAQY","OldValue":"2013-08-15"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G9EdVtAQK"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-01T02:58:42.000+0000","NewValue":700000,"Id":"017400000G9EdVtAQK","OldValue":650000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GEHgN4AQL"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-04T15:23:32.000+0000","NewValue":"Most Likely","Id":"017400000GEHgN4AQL","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GJ8Or3AQF"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-10T22:23:53.000+0000","NewValue":330000,"Id":"017400000GJ8Or3AQF","OldValue":227000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GQHc94AQD"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-18T15:58:39.000+0000","NewValue":"2013-09-30","Id":"017400000GQHc94AQD","OldValue":"2013-08-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GbWKUDAQ4"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-30T16:18:55.000+0000","NewValue":375000,"Id":"017400000GbWKUDAQ4","OldValue":330000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GbWLNSAQ4"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-30T16:18:55.000+0000","NewValue":750000,"Id":"017400000GbWLNSAQ4","OldValue":700000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGZdAQO"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:50:49.000+0000","NewValue":484500,"Id":"017400000H4UGZdAQO","OldValue":330000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGg8AQG"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:50:57.000+0000","NewValue":484500,"Id":"017400000H4UGg8AQG","OldValue":375000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UFv3AQG"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:51:07.000+0000","NewValue":375000,"Id":"017400000H4UFv3AQG","OldValue":484500},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGtmAQG"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:51:29.000+0000","NewValue":639800,"Id":"017400000H4UGtmAQG","OldValue":750000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H71oQYAQY"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-31T00:16:27.000+0000","NewValue":649,"Id":"017400000H71oQYAQY","OldValue":639800},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H71oU1AQI"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-31T00:16:45.000+0000","NewValue":649046,"Id":"017400000H71oU1AQI","OldValue":649},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEVoecAQD"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T15:27:09.000+0000","NewValue":649,"Id":"017400000HEVoecAQD","OldValue":484500},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEVoSmAQL"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T15:27:22.000+0000","NewValue":649046,"Id":"017400000HEVoSmAQL","OldValue":649},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEWkJYAQ1"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T18:09:21.000+0000","NewValue":"Most Likely","Id":"017400000HEWkJYAQ1","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HKwkDZAQZ"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-12T20:17:13.000+0000","NewValue":649046,"Id":"017400000HKwkDZAQZ","OldValue":375000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HLjnmSAQR"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-13T17:13:55.000+0000","NewValue":"Closing","Id":"017400000HLjnmSAQR","OldValue":"Due Diligence"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HLkBWgAQN"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-13T18:07:06.000+0000","NewValue":"2013-09-27","Id":"017400000HLkBWgAQN","OldValue":"2013-09-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HUclJXAQZ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-24T16:43:35.000+0000","NewValue":"2013-10-25","Id":"017400000HUclJXAQZ","OldValue":"2013-09-27"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HV9u1tAQB"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-25T12:26:59.000+0000","NewValue":"Commit","Id":"017400000HV9u1tAQB","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HV9yxEAQR"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-25T12:48:29.000+0000","NewValue":"Commit","Id":"017400000HV9yxEAQR","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HWrbFiAQJ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-26T21:48:27.000+0000","NewValue":"2013-11-15","Id":"017400000HWrbFiAQJ","OldValue":"2013-10-25"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HbU2ugAQC"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-01T17:23:16.000+0000","NewValue":"Commit","Id":"017400000HbU2ugAQC","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HepROSAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-05T12:54:01.000+0000","NewValue":"Commit","Id":"017400000HepROSAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Hz2x1dAQA"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-25T18:12:12.000+0000","NewValue":"Most Likely","Id":"017400000Hz2x1dAQA","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Hz3BMVAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-25T18:13:03.000+0000","NewValue":"Commit","Id":"017400000Hz3BMVAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I1GEQhAQO"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-28T15:36:46.000+0000","NewValue":"Commit","Id":"017400000I1GEQhAQO","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I670qfAQA"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-01T18:14:54.000+0000","NewValue":"Most Likely","Id":"017400000I670qfAQA","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I81UDiAQM"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-04T18:18:55.000+0000","NewValue":"Most Likely","Id":"017400000I81UDiAQM","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IA6TuZAQV"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-06T12:37:04.000+0000","NewValue":"2013-11-26","Id":"017400000IA6TuZAQV","OldValue":"2013-11-15"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IKiEtoAQF"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-18T14:32:48.000+0000","NewValue":"Upside","Id":"017400000IKiEtoAQF","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IKkeZbAQJ"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-18T22:22:17.000+0000","NewValue":"Upside","Id":"017400000IKkeZbAQJ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IRw3q7AQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-26T03:52:50.000+0000","NewValue":"2013-12-13","Id":"017400000IRw3q7AQB","OldValue":"2013-11-26"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IU0ZyTAQV"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-30T12:52:13.000+0000","NewValue":549000,"Id":"017400000IU0ZyTAQV","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IU0ZyYAQV"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-30T12:52:23.000+0000","NewValue":800000,"Id":"017400000IU0ZyYAQV","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IX562qAQB"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-03T20:26:32.000+0000","NewValue":602000,"Id":"017400000IX562qAQB","OldValue":549000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IX57SYAQZ"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-03T20:27:15.000+0000","NewValue":968000,"Id":"017400000IX57SYAQZ","OldValue":800000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYFAYzAQP"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-04T21:36:12.000+0000","NewValue":661000,"Id":"017400000IYFAYzAQP","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYF1gyAQD"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-04T21:36:29.000+0000","NewValue":981000,"Id":"017400000IYF1gyAQD","OldValue":968000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi67ZAQR"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:40.000+0000","NewValue":980000,"Id":"017400000IYi67ZAQR","OldValue":981000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi68JAQR"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:50.000+0000","NewValue":675000,"Id":"017400000IYi68JAQR","OldValue":661000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi6AEAQZ"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:58.000+0000","NewValue":661000,"Id":"017400000IYi6AEAQZ","OldValue":602000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Idamx4AQA"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-11T12:45:08.000+0000","NewValue":616982,"Id":"017400000Idamx4AQA","OldValue":661000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXAAQY"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":618000,"Id":"017400000Ie2eXAAQY","OldValue":675000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXBAQY"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":null,"Id":"017400000Ie2eXBAQY","OldValue":980000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXCAQY"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":618000,"Id":"017400000Ie2eXCAQY","OldValue":616982},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2dyDAQQ"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:10:12.000+0000","NewValue":"Most Likely","Id":"017400000Ie2dyDAQQ","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Iepfn5AQA"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T22:19:07.000+0000","NewValue":"Upside","Id":"017400000Iepfn5AQA","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IfKtx8AQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-13T14:11:11.000+0000","NewValue":"2014-01-17","Id":"017400000IfKtx8AQC","OldValue":"2013-12-13"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IfKtXGAQ0"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-13T14:11:13.000+0000","NewValue":"Commit","Id":"017400000IfKtXGAQ0","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IlL2cSAQS"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-23T15:47:16.000+0000","NewValue":648000,"Id":"017400000IlL2cSAQS","OldValue":618000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IlL2cyAQC"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-23T15:47:16.000+0000","NewValue":600000,"Id":"017400000IlL2cyAQC","OldValue":618000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IrEtdqAQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-30T16:59:33.000+0000","NewValue":"2014-01-24","Id":"017400000IrEtdqAQC","OldValue":"2014-01-17"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000ItCzNMAQ0"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-31T20:28:55.000+0000","NewValue":"Commit","Id":"017400000ItCzNMAQ0","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Iyu1zxAQA"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-08T03:57:14.000+0000","NewValue":"Most Likely","Id":"017400000Iyu1zxAQA","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0KtMLAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-09T22:37:20.000+0000","NewValue":"2014-01-31","Id":"017400000J0KtMLAQ0","OldValue":"2014-01-24"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0LdumAQC"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-10T01:31:38.000+0000","NewValue":845295,"Id":"017400000J0LdumAQC","OldValue":648000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0LdunAQC"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-10T01:31:38.000+0000","NewValue":658000,"Id":"017400000J0LdunAQC","OldValue":600000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J7M57jAQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-17T14:10:50.000+0000","NewValue":"2014-02-14","Id":"017400000J7M57jAQC","OldValue":"2014-01-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCsT0LAQV"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:23:42.000+0000","NewValue":8450000,"Id":"017400000JCsT0LAQV","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCrybaAQB"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:23:48.000+0000","NewValue":645295,"Id":"017400000JCrybaAQB","OldValue":845295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCsThnAQF"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:24:01.000+0000","NewValue":645295,"Id":"017400000JCsThnAQF","OldValue":658000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JIlw9EAQR"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-28T17:10:51.000+0000","NewValue":845000,"Id":"017400000JIlw9EAQR","OldValue":845000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JKf2HzAQJ"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-30T17:03:45.000+0000","NewValue":711539.49,"Id":"017400000JKf2HzAQJ","OldValue":645295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JKf31tAQB"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-30T17:03:45.000+0000","NewValue":711539.49,"Id":"017400000JKf31tAQB","OldValue":845000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JUPdU5AQL"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-10T15:33:50.000+0000","NewValue":"2014-02-21","Id":"017400000JUPdU5AQL","OldValue":"2014-02-14"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JXXx4GAQT"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-12T18:44:52.000+0000","NewValue":775024.26,"Id":"017400000JXXx4GAQT","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JXXx4HAQT"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-12T18:44:52.000+0000","NewValue":711539.49,"Id":"017400000JXXx4HAQT","OldValue":645295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPJlUAQW"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":"2014-02-26","Id":"017400000JdPJlUAQW","OldValue":"2014-02-21"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPLT3AQO"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":775024.26,"Id":"017400000JdPLT3AQO","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPLT4AQO"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":775024.26,"Id":"017400000JdPLT4AQO","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JeybSXAQY"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-21T21:42:43.000+0000","NewValue":"2014-02-28","Id":"017400000JeybSXAQY","OldValue":"2014-02-26"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JjQsnEAQS"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-26T22:46:49.000+0000","NewValue":"2014-03-07","Id":"017400000JjQsnEAQS","OldValue":"2014-02-28"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JmK1BZAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-02T03:30:42.000+0000","NewValue":"2014-03-14","Id":"017400000JmK1BZAQ0","OldValue":"2014-03-07"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JyTmxWAQS"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-13T13:23:45.000+0000","NewValue":"Most Likely","Id":"017400000JyTmxWAQS","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JzuGAEAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-14T14:16:58.000+0000","NewValue":"Upside","Id":"017400000JzuGAEAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JzuGD3AQM"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-14T14:17:10.000+0000","NewValue":"Most Likely","Id":"017400000JzuGD3AQM","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000K2hRUyAQM"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-17T19:39:20.000+0000","NewValue":"2014-03-28","Id":"017400000K2hRUyAQM","OldValue":"2014-03-14"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KDywHgAQJ"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-25T15:12:32.000+0000","NewValue":"Upside","Id":"017400000KDywHgAQJ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KE0muSAQR"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-25T17:46:35.000+0000","NewValue":"2014-04-11","Id":"017400000KE0muSAQR","OldValue":"2014-03-28"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KZUDaoAQH"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-08T18:17:00.000+0000","NewValue":"Most Likely","Id":"017400000KZUDaoAQH","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Kgb4vMAQQ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-14T15:31:42.000+0000","NewValue":"2014-04-30","Id":"017400000Kgb4vMAQQ","OldValue":"2014-04-11"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KoNIv2AQG"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-18T16:45:54.000+0000","NewValue":"2014-05-30","Id":"017400000KoNIv2AQG","OldValue":"2014-04-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L4ME6IAQW"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-05T18:39:55.000+0000","NewValue":"Upside","Id":"017400000L4ME6IAQW","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L8RDQHAQ4"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-09T14:26:00.000+0000","NewValue":"Most Likely","Id":"017400000L8RDQHAQ4","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L8RD7hAQG"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-09T14:26:03.000+0000","NewValue":"Upside","Id":"017400000L8RD7hAQG","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LEsa19AQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-16T21:50:17.000+0000","NewValue":"2014-06-20","Id":"017400000LEsa19AQB","OldValue":"2014-05-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LEsa2qAQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-16T21:50:26.000+0000","NewValue":"2014-06-18","Id":"017400000LEsa2qAQB","OldValue":"2014-06-20"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LFrGjrAQF"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-19T18:02:26.000+0000","NewValue":"Upside","Id":"017400000LFrGjrAQF","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LWWmrVAQT"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-02T16:54:59.000+0000","NewValue":"2014-06-23","Id":"017400000LWWmrVAQT","OldValue":"2014-06-18"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LbbcSLAQY"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-06T15:35:36.000+0000","NewValue":"Most Likely","Id":"017400000LbbcSLAQY","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lj26vdAQA"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-12T20:20:01.000+0000","NewValue":"Most Likely","Id":"017400000Lj26vdAQA","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LpQYYSAQ4"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-17T22:10:11.000+0000","NewValue":"2014-06-27","Id":"017400000LpQYYSAQ4","OldValue":"2014-06-23"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LqY6rLAQS"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-18T18:01:56.000+0000","NewValue":"Upside","Id":"017400000LqY6rLAQS","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxw2sZAQQ"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-24T19:11:22.000+0000","NewValue":"Upside","Id":"017400000Lxw2sZAQQ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxx3OvAQI"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-24T23:31:28.000+0000","NewValue":"Most Likely","Id":"017400000Lxx3OvAQI","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxxi3jAQA"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-25T02:01:53.000+0000","NewValue":"2014-06-30","Id":"017400000Lxxi3jAQA","OldValue":"2014-06-27"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LzR7SrAQK"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T14:19:55.000+0000","NewValue":"Procurement","Id":"017400000LzR7SrAQK","OldValue":"Closing"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LzRFapAQG"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T14:46:34.000+0000","NewValue":"Commit","Id":"017400000LzRFapAQG","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0QRWSAQ4"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T21:21:19.000+0000","NewValue":"PO in Channel","Id":"017400000M0QRWSAQ4","OldValue":"Procurement"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0QRSYAQ4"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T21:26:26.000+0000","NewValue":"Most Likely","Id":"017400000M0QRSYAQ4","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0Qh7EAQS"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T22:11:58.000+0000","NewValue":"Most Likely","Id":"017400000M0Qh7EAQS","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M1JtMJAQ0"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-27T19:23:56.000+0000","NewValue":1802382,"Id":"017400000M1JtMJAQ0","OldValue":775024.26},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M1K6EhAQK"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-27T20:04:42.000+0000","NewValue":775024.26,"Id":"017400000M1K6EhAQK","OldValue":1802382},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2QnKfAQK"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:04:51.000+0000","NewValue":"Commit","Id":"017400000M2QnKfAQK","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PDAQ0"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Closed/Won","Id":"017400000M2R6PDAQ0","OldValue":"PO in Channel"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PEAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"2014-06-28","Id":"017400000M2R6PEAQ0","OldValue":"2014-06-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PxAQK"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PxAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PyAQK"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PyAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PzAQK"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PzAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6Q0AQK"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6Q0AQK","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6Q1AQK"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6Q1AQK","OldValue":"Commit"}]},"StageName":"Closed/Won","Forecast_Category_VP__c":"Won","AmountLocal_SoftwareHigh__c":775024.26,"AmountLocal_SoftwareLow__c":775024.26,"AmountLocal_Software__c":775024.26,"Forecast_Category_Manager__c":"Won","Id":"0064000000QKK5qAAH","Forecast_Category_ISR__c":"Won","Forecast_Category_AVP__c":"Won","CloseDate":"2014-06-28","Forecast_Category_Rep__c":"Won","CreatedDate":"2014-04-01T10:30:11.000+0000"}]; var data = [ {date:"1-May-12",close:"58.13"}, {date:"30-Apr-12",close:"53.98"}, {date:"27-Apr-12",close:"67.00"}, {date:"26-Apr-12",close:"89.70"}, {date:"25-Apr-12",close:"99.00"} ]; //dataraw.Histories.foreach(function(d) { // data.add({date: d.}) //}); var margin = {top: 30, right: 20, bottom: 30, left: 50}, width = 600 - margin.left - margin.right, height = 270 - margin.top - margin.bottom; var parseDate = d3.time.format("%d-%b-%y").parse; var parseDateSfdc = d3.time.format("%Y-%m-%dT%H:%M:%S.%L%Z").parse; var x = d3.time.scale().range([0, width]); var y = d3.scale.linear().range([height, 0]); var xAxis = d3.svg.axis().scale(x) .orient("bottom").ticks(5); var yAxis = d3.svg.axis().scale(y) .orient("left").ticks(5); var valueline = d3.svg.line() .x(function(d) { return x(d.date); }) .y(function(d) { return y(d.AmountLocal_Software__c); }) .interpolate('step'); // Step between values instead of straight lines var highlowline = d3.svg.area() .x(function(d) { return x(d.date); }) .y0(function(d) { return y(d.AmountLocal_SoftwareHigh__c); }) .y1(function(d) { return y(d.AmountLocal_SoftwareLow__c); }) .interpolate('step'); // Step between values instead of straight lines var svg = d3.select("body") .append("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")" ); // Get the data //d3.tsv("data/data.tsv", function(error, data) { //data.forEach(function(d) { // d.date = parseDate(d.date); // d.close = +d.close; //}); var dateHash = {}; var dateArray = []; var todayDate = new Date(Date.now()); var today = todayDate.toISOString().substring(0,23) + '+0000'; // Entry for right now which picks up current values if (rawdata[0].StageName.substring(0,5) != 'Close') { dateHash[today] = { date: parseDateSfdc(today), changeDate: today }; dateArray.push(today); } // Entry for when the oppt was created dateHash[rawdata[0].CreatedDate] = { date: parseDateSfdc(rawdata[0].CreatedDate), changeDate: rawdata[0].CreatedDate }; dateArray.push(rawdata[0].CreatedDate); //Step through all the changes tracking changed fields rawdata[0].Histories.records.forEach(function(d) { if (!dateHash.hasOwnProperty(d.CreatedDate)) { dateHash[d.CreatedDate] = { date: parseDateSfdc(d.CreatedDate), changeDate: d.CreatedDate }; dateArray.push(d.CreatedDate); } dateHash[d.CreatedDate][d.Field] = d.OldValue; if (d.OldValue > 1000000) { console.log(d.CreatedDate); } }); //TODO Add current date values if open //TODO Add create date values //console.log (dateHash); var newdata=[]; //newdata[0].date = parseDateSfdc(rawdata[0].CloseDate); // take min of close date and current date //newdata[0].close = +rawdata[0].AmountLocal_Software__c; // Add entry for creation date - and use the "old value" of the first change for it // If there is no history, use the current value for the creation entry dateArray.sort().reverse(); var previous = {}; // Load current values for (var f in fields) { previous[f] = rawdata[0][f]; } //console.log(rawdata[0].Histories.records); //rawdata[0].Histories.records. //for (var date in dateHash) { dateArray.forEach(function(date) { for (var f in fields) { if (dateHash[date].hasOwnProperty(f)) { previous[f] = dateHash[date][f]; } else { dateHash[date][f] = previous[f]; } } newdata.push(dateHash[date]); // console.log(dateHash[date]); //} }); data = newdata; // Scale the range of the data x.domain(d3.extent(data, function(d) { return d.date; })); y.domain([0, d3.max(data, function(d) { return Math.max( d.AmountLocal_Software__c, d.AmountLocal_SoftwareHigh__c || 0); })]); svg.append("path") // Add the valueline path. .attr("class", "area") .attr("d", highlowline(data)); svg.append("path") // Add the valueline path. .attr("d", valueline(data)); svg.append("g") // Add the X Axis .attr("class", "x axis") .attr("transform", "translate(0," + height + ")") .call(xAxis); svg.append("g") // Add the Y Axis .attr("class", "y axis") .call(yAxis); //}); /* */ </script> <script id="jsbin-source-css" type="text/css"> body { font: 12px Arial;} path { stroke: steelblue; stroke-width: 2; fill: none; } .axis path, .axis line { fill: none; stroke: grey; stroke-width: 1; shape-rendering: crispEdges; } .area { fill: tan; stroke: none; stroke-width: 1; }</script> <script id="jsbin-source-javascript" type="text/javascript">// Amounts: Draw the line from the current date to the next date horizontally, then vertically to the new value. // If the close date is in the past, use the close date as the right x axis // If the close date is in the future, use the current date as the right x axis // Go one day past the close date or current date so a line is drawn /* APEX to generate JSON //0064000000QKK5qAAH' 0064000000YMH0VAAX' List<Opportunity> oList = [SELECT Id , AmountLocal_Software__c , AmountLocal_SoftwareHigh__c , AmountLocal_SoftwareLow__c , CloseDate , Forecast_Category_AVP__c , Forecast_Category_ISR__c , Forecast_Category_Manager__c , Forecast_Category_Rep__c , Forecast_Category_VP__c , StageName , CreatedDate , (Select OldValue, NewValue, CreatedDate, Field From Histories where Field IN ('AmountLocal_Software__c' , 'AmountLocal_SoftwareHigh__c' , 'AmountLocal_SoftwareLow__c' , 'CloseDate' , 'Forecast_Category_AVP__c' , 'Forecast_Category_ISR__c' , 'Forecast_Category_Manager__c' , 'Forecast_Category_Rep__c' , 'Forecast_Category_VP__c' , 'StageName') ORDER BY createdDate DESC ) FROM Opportunity WHERE ID = '0064000000QKK5qAAH' LIMIT 1 ]; System.Debug(JSON.serialize(oList)); */ var fields = { AmountLocal_Software__c : 1, AmountLocal_SoftwareHigh__c : 1, AmountLocal_SoftwareLow__c : 1, // CloseDate : 1, // Forecast_Category_AVP__c : 1, // Forecast_Category_ISR__c : 1, // Forecast_Category_Manager__c : 1, // Forecast_Category_Rep__c : 1, // Forecast_Category_VP__c : 1, // StageName : 1 }; var rawdata = [{ "attributes": {"type":"Opportunity","url":"/services/data/v31.0/sobjects/Opportunity/0064000000YMH0VAAX"}, "Histories":{ "totalSize":5, "done":true, "records":[{ "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-10T10:30:11.000+0000", "NewValue":40000, "Id":"017400000Nk3o66AQA", "OldValue":50000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-15T10:30:11.000+0000", "NewValue":30000, "Id":"017400000Nk3o66AQA", "OldValue":40000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-09-30T10:30:11.000+0000", "NewValue":20000, "Id":"017400000Nk3o66AQA", "OldValue":30000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-10-10T10:30:11.000+0000", "NewValue":15000, "Id":"017400000Nk3o66AQA", "OldValue":20000, "Field":"AmountLocal_SoftwareHigh__c" }, { "attributes":{ "type":"OpportunityFieldHistory", "url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Nk3o66AQA" }, "OpportunityId":"0064000000YMH0VAAX", "CreatedDate":"2014-10-12T10:30:11.000+0000", "NewValue":10000, "Id":"017400000Nk3o66AQA", "OldValue":15000, "Field":"AmountLocal_SoftwareHigh__c" } ]}, "StageName":"Due Diligence", "CreatedDate":"2014-08-01T10:30:11.000+0000", "AmountLocal_SoftwareHigh__c":10000.00, "AmountLocal_Software__c":9250.00, "AmountLocal_SoftwareLow__c":1000.00, "Id":"0064000000YMH0VAAX", "CloseDate":"2015-01-30", "Forecast_Category_Rep__c":"Upside" }]; rawdata =[{"attributes":{"type":"Opportunity","url":"/services/data/v31.0/sobjects/Opportunity/0064000000QKK5qAAH"},"Histories":{"totalSize":126,"done":true,"records":[{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000F3VlQeAQK"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-04-08T20:05:53.000+0000","NewValue":"2013-04-30","Id":"017400000F3VlQeAQK","OldValue":"2013-03-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVohdAQD"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:45:20.000+0000","NewValue":"2013-07-31","Id":"017400000FTVohdAQD","OldValue":"2013-04-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVtFQAQ1"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:48:43.000+0000","NewValue":"Qualification","Id":"017400000FTVtFQAQ1","OldValue":"Sales Qualified Lead"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FTVtTxAQL"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-13T15:48:43.000+0000","NewValue":"Most Likely","Id":"017400000FTVtTxAQL","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FdKNw6AQG"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-05-24T12:29:04.000+0000","NewValue":"Most Likely","Id":"017400000FdKNw6AQG","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FmkcN8AQI"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-04T14:52:57.000+0000","NewValue":"2013-08-15","Id":"017400000FmkcN8AQI","OldValue":"2013-07-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FtAKCNAQ4"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-12T19:51:47.000+0000","NewValue":550000,"Id":"017400000FtAKCNAQ4","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000FxmEITAQ2"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-17T22:27:34.000+0000","NewValue":227000,"Id":"017400000FxmEITAQ2","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn01UAQQ"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:42:06.000+0000","NewValue":275000,"Id":"017400000Fxn01UAQQ","OldValue":550000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn01VAQQ"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:42:06.000+0000","NewValue":650000,"Id":"017400000Fxn01VAQQ","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Fxn1pcAQA"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-18T01:45:20.000+0000","NewValue":330000,"Id":"017400000Fxn1pcAQA","OldValue":275000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4l4V0AQI"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-26T13:20:57.000+0000","NewValue":"Most Likely","Id":"017400000G4l4V0AQI","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4nyQBAQY"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-27T01:16:53.000+0000","NewValue":"Due Diligence","Id":"017400000G4nyQBAQY","OldValue":"Qualification"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G4nyQCAQY"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-06-27T01:16:53.000+0000","NewValue":"2013-08-30","Id":"017400000G4nyQCAQY","OldValue":"2013-08-15"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000G9EdVtAQK"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-01T02:58:42.000+0000","NewValue":700000,"Id":"017400000G9EdVtAQK","OldValue":650000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GEHgN4AQL"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-04T15:23:32.000+0000","NewValue":"Most Likely","Id":"017400000GEHgN4AQL","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GJ8Or3AQF"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-10T22:23:53.000+0000","NewValue":330000,"Id":"017400000GJ8Or3AQF","OldValue":227000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GQHc94AQD"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-18T15:58:39.000+0000","NewValue":"2013-09-30","Id":"017400000GQHc94AQD","OldValue":"2013-08-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GbWKUDAQ4"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-30T16:18:55.000+0000","NewValue":375000,"Id":"017400000GbWKUDAQ4","OldValue":330000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000GbWLNSAQ4"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-07-30T16:18:55.000+0000","NewValue":750000,"Id":"017400000GbWLNSAQ4","OldValue":700000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGZdAQO"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:50:49.000+0000","NewValue":484500,"Id":"017400000H4UGZdAQO","OldValue":330000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGg8AQG"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:50:57.000+0000","NewValue":484500,"Id":"017400000H4UGg8AQG","OldValue":375000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UFv3AQG"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:51:07.000+0000","NewValue":375000,"Id":"017400000H4UFv3AQG","OldValue":484500},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H4UGtmAQG"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-28T15:51:29.000+0000","NewValue":639800,"Id":"017400000H4UGtmAQG","OldValue":750000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H71oQYAQY"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-31T00:16:27.000+0000","NewValue":649,"Id":"017400000H71oQYAQY","OldValue":639800},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000H71oU1AQI"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-08-31T00:16:45.000+0000","NewValue":649046,"Id":"017400000H71oU1AQI","OldValue":649},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEVoecAQD"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T15:27:09.000+0000","NewValue":649,"Id":"017400000HEVoecAQD","OldValue":484500},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEVoSmAQL"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T15:27:22.000+0000","NewValue":649046,"Id":"017400000HEVoSmAQL","OldValue":649},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HEWkJYAQ1"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-06T18:09:21.000+0000","NewValue":"Most Likely","Id":"017400000HEWkJYAQ1","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HKwkDZAQZ"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-12T20:17:13.000+0000","NewValue":649046,"Id":"017400000HKwkDZAQZ","OldValue":375000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HLjnmSAQR"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-13T17:13:55.000+0000","NewValue":"Closing","Id":"017400000HLjnmSAQR","OldValue":"Due Diligence"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HLkBWgAQN"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-13T18:07:06.000+0000","NewValue":"2013-09-27","Id":"017400000HLkBWgAQN","OldValue":"2013-09-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HUclJXAQZ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-24T16:43:35.000+0000","NewValue":"2013-10-25","Id":"017400000HUclJXAQZ","OldValue":"2013-09-27"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HV9u1tAQB"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-25T12:26:59.000+0000","NewValue":"Commit","Id":"017400000HV9u1tAQB","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HV9yxEAQR"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-25T12:48:29.000+0000","NewValue":"Commit","Id":"017400000HV9yxEAQR","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HWrbFiAQJ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-09-26T21:48:27.000+0000","NewValue":"2013-11-15","Id":"017400000HWrbFiAQJ","OldValue":"2013-10-25"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HbU2ugAQC"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-01T17:23:16.000+0000","NewValue":"Commit","Id":"017400000HbU2ugAQC","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000HepROSAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-05T12:54:01.000+0000","NewValue":"Commit","Id":"017400000HepROSAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Hz2x1dAQA"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-25T18:12:12.000+0000","NewValue":"Most Likely","Id":"017400000Hz2x1dAQA","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Hz3BMVAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-25T18:13:03.000+0000","NewValue":"Commit","Id":"017400000Hz3BMVAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I1GEQhAQO"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-10-28T15:36:46.000+0000","NewValue":"Commit","Id":"017400000I1GEQhAQO","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I670qfAQA"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-01T18:14:54.000+0000","NewValue":"Most Likely","Id":"017400000I670qfAQA","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000I81UDiAQM"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-04T18:18:55.000+0000","NewValue":"Most Likely","Id":"017400000I81UDiAQM","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IA6TuZAQV"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-06T12:37:04.000+0000","NewValue":"2013-11-26","Id":"017400000IA6TuZAQV","OldValue":"2013-11-15"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IKiEtoAQF"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-18T14:32:48.000+0000","NewValue":"Upside","Id":"017400000IKiEtoAQF","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IKkeZbAQJ"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-18T22:22:17.000+0000","NewValue":"Upside","Id":"017400000IKkeZbAQJ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IRw3q7AQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-26T03:52:50.000+0000","NewValue":"2013-12-13","Id":"017400000IRw3q7AQB","OldValue":"2013-11-26"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IU0ZyTAQV"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-30T12:52:13.000+0000","NewValue":549000,"Id":"017400000IU0ZyTAQV","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IU0ZyYAQV"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-11-30T12:52:23.000+0000","NewValue":800000,"Id":"017400000IU0ZyYAQV","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IX562qAQB"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-03T20:26:32.000+0000","NewValue":602000,"Id":"017400000IX562qAQB","OldValue":549000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IX57SYAQZ"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-03T20:27:15.000+0000","NewValue":968000,"Id":"017400000IX57SYAQZ","OldValue":800000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYFAYzAQP"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-04T21:36:12.000+0000","NewValue":661000,"Id":"017400000IYFAYzAQP","OldValue":649046},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYF1gyAQD"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-04T21:36:29.000+0000","NewValue":981000,"Id":"017400000IYF1gyAQD","OldValue":968000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi67ZAQR"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:40.000+0000","NewValue":980000,"Id":"017400000IYi67ZAQR","OldValue":981000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi68JAQR"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:50.000+0000","NewValue":675000,"Id":"017400000IYi68JAQR","OldValue":661000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IYi6AEAQZ"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-05T16:57:58.000+0000","NewValue":661000,"Id":"017400000IYi6AEAQZ","OldValue":602000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Idamx4AQA"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-11T12:45:08.000+0000","NewValue":616982,"Id":"017400000Idamx4AQA","OldValue":661000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXAAQY"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":618000,"Id":"017400000Ie2eXAAQY","OldValue":675000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXBAQY"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":null,"Id":"017400000Ie2eXBAQY","OldValue":980000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2eXCAQY"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:09:50.000+0000","NewValue":618000,"Id":"017400000Ie2eXCAQY","OldValue":616982},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Ie2dyDAQQ"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T15:10:12.000+0000","NewValue":"Most Likely","Id":"017400000Ie2dyDAQQ","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Iepfn5AQA"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-12T22:19:07.000+0000","NewValue":"Upside","Id":"017400000Iepfn5AQA","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IfKtx8AQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-13T14:11:11.000+0000","NewValue":"2014-01-17","Id":"017400000IfKtx8AQC","OldValue":"2013-12-13"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IfKtXGAQ0"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-13T14:11:13.000+0000","NewValue":"Commit","Id":"017400000IfKtXGAQ0","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IlL2cSAQS"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-23T15:47:16.000+0000","NewValue":648000,"Id":"017400000IlL2cSAQS","OldValue":618000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IlL2cyAQC"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-23T15:47:16.000+0000","NewValue":600000,"Id":"017400000IlL2cyAQC","OldValue":618000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000IrEtdqAQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-30T16:59:33.000+0000","NewValue":"2014-01-24","Id":"017400000IrEtdqAQC","OldValue":"2014-01-17"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000ItCzNMAQ0"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2013-12-31T20:28:55.000+0000","NewValue":"Commit","Id":"017400000ItCzNMAQ0","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Iyu1zxAQA"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-08T03:57:14.000+0000","NewValue":"Most Likely","Id":"017400000Iyu1zxAQA","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0KtMLAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-09T22:37:20.000+0000","NewValue":"2014-01-31","Id":"017400000J0KtMLAQ0","OldValue":"2014-01-24"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0LdumAQC"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-10T01:31:38.000+0000","NewValue":845295,"Id":"017400000J0LdumAQC","OldValue":648000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J0LdunAQC"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-10T01:31:38.000+0000","NewValue":658000,"Id":"017400000J0LdunAQC","OldValue":600000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000J7M57jAQC"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-17T14:10:50.000+0000","NewValue":"2014-02-14","Id":"017400000J7M57jAQC","OldValue":"2014-01-31"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCsT0LAQV"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:23:42.000+0000","NewValue":8450000,"Id":"017400000JCsT0LAQV","OldValue":null},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCrybaAQB"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:23:48.000+0000","NewValue":645295,"Id":"017400000JCrybaAQB","OldValue":845295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JCsThnAQF"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-22T13:24:01.000+0000","NewValue":645295,"Id":"017400000JCsThnAQF","OldValue":658000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JIlw9EAQR"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-28T17:10:51.000+0000","NewValue":845000,"Id":"017400000JIlw9EAQR","OldValue":845000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JKf2HzAQJ"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-30T17:03:45.000+0000","NewValue":711539.49,"Id":"017400000JKf2HzAQJ","OldValue":645295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JKf31tAQB"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-01-30T17:03:45.000+0000","NewValue":711539.49,"Id":"017400000JKf31tAQB","OldValue":845000},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JUPdU5AQL"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-10T15:33:50.000+0000","NewValue":"2014-02-21","Id":"017400000JUPdU5AQL","OldValue":"2014-02-14"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JXXx4GAQT"},"Field":"AmountLocal_SoftwareHigh__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-12T18:44:52.000+0000","NewValue":775024.26,"Id":"017400000JXXx4GAQT","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JXXx4HAQT"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-12T18:44:52.000+0000","NewValue":711539.49,"Id":"017400000JXXx4HAQT","OldValue":645295},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPJlUAQW"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":"2014-02-26","Id":"017400000JdPJlUAQW","OldValue":"2014-02-21"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPLT3AQO"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":775024.26,"Id":"017400000JdPLT3AQO","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JdPLT4AQO"},"Field":"AmountLocal_SoftwareLow__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-19T16:15:38.000+0000","NewValue":775024.26,"Id":"017400000JdPLT4AQO","OldValue":711539.49},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JeybSXAQY"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-21T21:42:43.000+0000","NewValue":"2014-02-28","Id":"017400000JeybSXAQY","OldValue":"2014-02-26"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JjQsnEAQS"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-02-26T22:46:49.000+0000","NewValue":"2014-03-07","Id":"017400000JjQsnEAQS","OldValue":"2014-02-28"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JmK1BZAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-02T03:30:42.000+0000","NewValue":"2014-03-14","Id":"017400000JmK1BZAQ0","OldValue":"2014-03-07"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JyTmxWAQS"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-13T13:23:45.000+0000","NewValue":"Most Likely","Id":"017400000JyTmxWAQS","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JzuGAEAQ2"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-14T14:16:58.000+0000","NewValue":"Upside","Id":"017400000JzuGAEAQ2","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000JzuGD3AQM"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-14T14:17:10.000+0000","NewValue":"Most Likely","Id":"017400000JzuGD3AQM","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000K2hRUyAQM"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-17T19:39:20.000+0000","NewValue":"2014-03-28","Id":"017400000K2hRUyAQM","OldValue":"2014-03-14"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KDywHgAQJ"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-25T15:12:32.000+0000","NewValue":"Upside","Id":"017400000KDywHgAQJ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KE0muSAQR"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-03-25T17:46:35.000+0000","NewValue":"2014-04-11","Id":"017400000KE0muSAQR","OldValue":"2014-03-28"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KZUDaoAQH"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-08T18:17:00.000+0000","NewValue":"Most Likely","Id":"017400000KZUDaoAQH","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Kgb4vMAQQ"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-14T15:31:42.000+0000","NewValue":"2014-04-30","Id":"017400000Kgb4vMAQQ","OldValue":"2014-04-11"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000KoNIv2AQG"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-04-18T16:45:54.000+0000","NewValue":"2014-05-30","Id":"017400000KoNIv2AQG","OldValue":"2014-04-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L4ME6IAQW"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-05T18:39:55.000+0000","NewValue":"Upside","Id":"017400000L4ME6IAQW","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L8RDQHAQ4"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-09T14:26:00.000+0000","NewValue":"Most Likely","Id":"017400000L8RDQHAQ4","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000L8RD7hAQG"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-09T14:26:03.000+0000","NewValue":"Upside","Id":"017400000L8RD7hAQG","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LEsa19AQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-16T21:50:17.000+0000","NewValue":"2014-06-20","Id":"017400000LEsa19AQB","OldValue":"2014-05-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LEsa2qAQB"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-16T21:50:26.000+0000","NewValue":"2014-06-18","Id":"017400000LEsa2qAQB","OldValue":"2014-06-20"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LFrGjrAQF"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-05-19T18:02:26.000+0000","NewValue":"Upside","Id":"017400000LFrGjrAQF","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LWWmrVAQT"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-02T16:54:59.000+0000","NewValue":"2014-06-23","Id":"017400000LWWmrVAQT","OldValue":"2014-06-18"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LbbcSLAQY"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-06T15:35:36.000+0000","NewValue":"Most Likely","Id":"017400000LbbcSLAQY","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lj26vdAQA"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-12T20:20:01.000+0000","NewValue":"Most Likely","Id":"017400000Lj26vdAQA","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LpQYYSAQ4"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-17T22:10:11.000+0000","NewValue":"2014-06-27","Id":"017400000LpQYYSAQ4","OldValue":"2014-06-23"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LqY6rLAQS"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-18T18:01:56.000+0000","NewValue":"Upside","Id":"017400000LqY6rLAQS","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxw2sZAQQ"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-24T19:11:22.000+0000","NewValue":"Upside","Id":"017400000Lxw2sZAQQ","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxx3OvAQI"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-24T23:31:28.000+0000","NewValue":"Most Likely","Id":"017400000Lxx3OvAQI","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000Lxxi3jAQA"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-25T02:01:53.000+0000","NewValue":"2014-06-30","Id":"017400000Lxxi3jAQA","OldValue":"2014-06-27"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LzR7SrAQK"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T14:19:55.000+0000","NewValue":"Procurement","Id":"017400000LzR7SrAQK","OldValue":"Closing"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000LzRFapAQG"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T14:46:34.000+0000","NewValue":"Commit","Id":"017400000LzRFapAQG","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0QRWSAQ4"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T21:21:19.000+0000","NewValue":"PO in Channel","Id":"017400000M0QRWSAQ4","OldValue":"Procurement"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0QRSYAQ4"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T21:26:26.000+0000","NewValue":"Most Likely","Id":"017400000M0QRSYAQ4","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M0Qh7EAQS"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-26T22:11:58.000+0000","NewValue":"Most Likely","Id":"017400000M0Qh7EAQS","OldValue":"Upside"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M1JtMJAQ0"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-27T19:23:56.000+0000","NewValue":1802382,"Id":"017400000M1JtMJAQ0","OldValue":775024.26},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M1K6EhAQK"},"Field":"AmountLocal_Software__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-27T20:04:42.000+0000","NewValue":775024.26,"Id":"017400000M1K6EhAQK","OldValue":1802382},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2QnKfAQK"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:04:51.000+0000","NewValue":"Commit","Id":"017400000M2QnKfAQK","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PDAQ0"},"Field":"StageName","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Closed/Won","Id":"017400000M2R6PDAQ0","OldValue":"PO in Channel"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PEAQ0"},"Field":"CloseDate","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"2014-06-28","Id":"017400000M2R6PEAQ0","OldValue":"2014-06-30"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PxAQK"},"Field":"Forecast_Category_Manager__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PxAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PyAQK"},"Field":"Forecast_Category_ISR__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PyAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6PzAQK"},"Field":"Forecast_Category_Rep__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6PzAQK","OldValue":"Commit"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6Q0AQK"},"Field":"Forecast_Category_VP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6Q0AQK","OldValue":"Most Likely"},{"attributes":{"type":"OpportunityFieldHistory","url":"/services/data/v31.0/sobjects/OpportunityFieldHistory/017400000M2R6Q1AQK"},"Field":"Forecast_Category_AVP__c","OpportunityId":"0064000000QKK5qAAH","CreatedDate":"2014-06-30T13:28:40.000+0000","NewValue":"Won","Id":"017400000M2R6Q1AQK","OldValue":"Commit"}]},"StageName":"Closed/Won","Forecast_Category_VP__c":"Won","AmountLocal_SoftwareHigh__c":775024.26,"AmountLocal_SoftwareLow__c":775024.26,"AmountLocal_Software__c":775024.26,"Forecast_Category_Manager__c":"Won","Id":"0064000000QKK5qAAH","Forecast_Category_ISR__c":"Won","Forecast_Category_AVP__c":"Won","CloseDate":"2014-06-28","Forecast_Category_Rep__c":"Won","CreatedDate":"2014-04-01T10:30:11.000+0000"}]; var data = [ {date:"1-May-12",close:"58.13"}, {date:"30-Apr-12",close:"53.98"}, {date:"27-Apr-12",close:"67.00"}, {date:"26-Apr-12",close:"89.70"}, {date:"25-Apr-12",close:"99.00"} ]; //dataraw.Histories.foreach(function(d) { // data.add({date: d.}) //}); var margin = {top: 30, right: 20, bottom: 30, left: 50}, width = 600 - margin.left - margin.right, height = 270 - margin.top - margin.bottom; var parseDate = d3.time.format("%d-%b-%y").parse; var parseDateSfdc = d3.time.format("%Y-%m-%dT%H:%M:%S.%L%Z").parse; var x = d3.time.scale().range([0, width]); var y = d3.scale.linear().range([height, 0]); var xAxis = d3.svg.axis().scale(x) .orient("bottom").ticks(5); var yAxis = d3.svg.axis().scale(y) .orient("left").ticks(5); var valueline = d3.svg.line() .x(function(d) { return x(d.date); }) .y(function(d) { return y(d.AmountLocal_Software__c); }) .interpolate('step'); // Step between values instead of straight lines var highlowline = d3.svg.area() .x(function(d) { return x(d.date); }) .y0(function(d) { return y(d.AmountLocal_SoftwareHigh__c); }) .y1(function(d) { return y(d.AmountLocal_SoftwareLow__c); }) .interpolate('step'); // Step between values instead of straight lines var svg = d3.select("body") .append("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")" ); // Get the data //d3.tsv("data/data.tsv", function(error, data) { //data.forEach(function(d) { // d.date = parseDate(d.date); // d.close = +d.close; //}); var dateHash = {}; var dateArray = []; var todayDate = new Date(Date.now()); var today = todayDate.toISOString().substring(0,23) + '+0000'; // Entry for right now which picks up current values if (rawdata[0].StageName.substring(0,5) != 'Close') { dateHash[today] = { date: parseDateSfdc(today), changeDate: today }; dateArray.push(today); } // Entry for when the oppt was created dateHash[rawdata[0].CreatedDate] = { date: parseDateSfdc(rawdata[0].CreatedDate), changeDate: rawdata[0].CreatedDate }; dateArray.push(rawdata[0].CreatedDate); //Step through all the changes tracking changed fields rawdata[0].Histories.records.forEach(function(d) { if (!dateHash.hasOwnProperty(d.CreatedDate)) { dateHash[d.CreatedDate] = { date: parseDateSfdc(d.CreatedDate), changeDate: d.CreatedDate }; dateArray.push(d.CreatedDate); } dateHash[d.CreatedDate][d.Field] = d.OldValue; if (d.OldValue > 1000000) { console.log(d.CreatedDate); } }); //TODO Add current date values if open //TODO Add create date values //console.log (dateHash); var newdata=[]; //newdata[0].date = parseDateSfdc(rawdata[0].CloseDate); // take min of close date and current date //newdata[0].close = +rawdata[0].AmountLocal_Software__c; // Add entry for creation date - and use the "old value" of the first change for it // If there is no history, use the current value for the creation entry dateArray.sort().reverse(); var previous = {}; // Load current values for (var f in fields) { previous[f] = rawdata[0][f]; } //console.log(rawdata[0].Histories.records); //rawdata[0].Histories.records. //for (var date in dateHash) { dateArray.forEach(function(date) { for (var f in fields) { if (dateHash[date].hasOwnProperty(f)) { previous[f] = dateHash[date][f]; } else { dateHash[date][f] = previous[f]; } } newdata.push(dateHash[date]); // console.log(dateHash[date]); //} }); data = newdata; // Scale the range of the data x.domain(d3.extent(data, function(d) { return d.date; })); y.domain([0, d3.max(data, function(d) { return Math.max( d.AmountLocal_Software__c, d.AmountLocal_SoftwareHigh__c || 0); })]); svg.append("path") // Add the valueline path. .attr("class", "area") .attr("d", highlowline(data)); svg.append("path") // Add the valueline path. .attr("d", valueline(data)); svg.append("g") // Add the X Axis .attr("class", "x axis") .attr("transform", "translate(0," + height + ")") .call(xAxis); svg.append("g") // Add the Y Axis .attr("class", "y axis") .call(yAxis); //}); /* */</script></body>
Modified
http://d3js.org/d3.v3.min.js
to a secure url
https://d3js.org/d3.v3.min.js