Skip to content

Instantly share code, notes, and snippets.

@empiimp

empiimp/index.html

Created March 24, 2015 13:48
Show Gist options
  • Save empiimp/2a04a46cd4ce1854540c to your computer and use it in GitHub Desktop.
Save empiimp/2a04a46cd4ce1854540c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
index.html
<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="http://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: 75},
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: 75},
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>
Raw
jsbin.bopewi.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;
}
Raw
jsbin.bopewi.js
// 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: 75},
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);
//});
/* */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment