{"help": "https://open.scayle.es/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "adf6b866-e57c-4ed9-aecd-a5f566ebbb2e", "total_estimation_threshold": null, "records": [{"_id":1,"Segment":"Government","Country":"Canada","Product":"Carretera","Discount Band":"None","Units Sold":"1618.5","Manufacturing Price":"3","Sale Price":"20","Gross Sales":"32370","Discounts":"0","Sales":"32370","COGS":"16185","Profit":"16185","Date":"2014-01-01 00:00:00","Month Number":"1","Month Name":"January","Year":"2014"},{"_id":2,"Segment":"Government","Country":"Germany","Product":"Carretera","Discount Band":"None","Units Sold":"1321","Manufacturing Price":"3","Sale Price":"20","Gross Sales":"26420","Discounts":"0","Sales":"26420","COGS":"13210","Profit":"13210","Date":"2014-01-01 00:00:00","Month Number":"1","Month Name":"January","Year":"2014"},{"_id":3,"Segment":"Midmarket","Country":"France","Product":"Carretera","Discount Band":"None","Units Sold":"2178","Manufacturing Price":"3","Sale Price":"15","Gross Sales":"32670","Discounts":"0","Sales":"32670","COGS":"21780","Profit":"10890","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":4,"Segment":"Midmarket","Country":"Germany","Product":"Carretera","Discount Band":"None","Units Sold":"888","Manufacturing Price":"3","Sale Price":"15","Gross Sales":"13320","Discounts":"0","Sales":"13320","COGS":"8880","Profit":"4440","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":5,"Segment":"Midmarket","Country":"Mexico","Product":"Carretera","Discount Band":"None","Units Sold":"2470","Manufacturing Price":"3","Sale Price":"15","Gross Sales":"37050","Discounts":"0","Sales":"37050","COGS":"24700","Profit":"12350","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":6,"Segment":"Government","Country":"Germany","Product":"Carretera","Discount Band":"None","Units Sold":"1513","Manufacturing Price":"3","Sale Price":"350","Gross Sales":"529550","Discounts":"0","Sales":"529550","COGS":"393380","Profit":"136170","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":7,"Segment":"Midmarket","Country":"Germany","Product":"Montana","Discount Band":"None","Units Sold":"921","Manufacturing Price":"5","Sale Price":"15","Gross Sales":"13815","Discounts":"0","Sales":"13815","COGS":"9210","Profit":"4605","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":8,"Segment":"Channel Partners","Country":"Canada","Product":"Montana","Discount Band":"None","Units Sold":"2518","Manufacturing Price":"5","Sale Price":"12","Gross Sales":"30216","Discounts":"0","Sales":"30216","COGS":"7554","Profit":"22662","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":9,"Segment":"Government","Country":"France","Product":"Montana","Discount Band":"None","Units Sold":"1899","Manufacturing Price":"5","Sale Price":"20","Gross Sales":"37980","Discounts":"0","Sales":"37980","COGS":"18990","Profit":"18990","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":10,"Segment":"Channel Partners","Country":"Germany","Product":"Montana","Discount Band":"None","Units Sold":"1545","Manufacturing Price":"5","Sale Price":"12","Gross Sales":"18540","Discounts":"0","Sales":"18540","COGS":"4635","Profit":"13905","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":11,"Segment":"Midmarket","Country":"Mexico","Product":"Montana","Discount Band":"None","Units Sold":"2470","Manufacturing Price":"5","Sale Price":"15","Gross Sales":"37050","Discounts":"0","Sales":"37050","COGS":"24700","Profit":"12350","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":12,"Segment":"Enterprise","Country":"Canada","Product":"Montana","Discount Band":"None","Units Sold":"2665.5","Manufacturing Price":"5","Sale Price":"125","Gross Sales":"333187.5","Discounts":"0","Sales":"333187.5","COGS":"319860","Profit":"13327.5","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":13,"Segment":"Small Business","Country":"Mexico","Product":"Montana","Discount Band":"None","Units Sold":"958","Manufacturing Price":"5","Sale Price":"300","Gross Sales":"287400","Discounts":"0","Sales":"287400","COGS":"239500","Profit":"47900","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":14,"Segment":"Government","Country":"Germany","Product":"Montana","Discount Band":"None","Units Sold":"2146","Manufacturing Price":"5","Sale Price":"7","Gross Sales":"15022","Discounts":"0","Sales":"15022","COGS":"10730","Profit":"4292","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":15,"Segment":"Enterprise","Country":"Canada","Product":"Montana","Discount Band":"None","Units Sold":"345","Manufacturing Price":"5","Sale Price":"125","Gross Sales":"43125","Discounts":"0","Sales":"43125","COGS":"41400","Profit":"1725","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":16,"Segment":"Midmarket","Country":"United States of America","Product":"Montana","Discount Band":"None","Units Sold":"615","Manufacturing Price":"5","Sale Price":"15","Gross Sales":"9225","Discounts":"0","Sales":"9225","COGS":"6150","Profit":"3075","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":17,"Segment":"Government","Country":"Canada","Product":"Paseo","Discount Band":"None","Units Sold":"292","Manufacturing Price":"10","Sale Price":"20","Gross Sales":"5840","Discounts":"0","Sales":"5840","COGS":"2920","Profit":"2920","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":18,"Segment":"Midmarket","Country":"Mexico","Product":"Paseo","Discount Band":"None","Units Sold":"974","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"14610","Discounts":"0","Sales":"14610","COGS":"9740","Profit":"4870","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":19,"Segment":"Channel Partners","Country":"Canada","Product":"Paseo","Discount Band":"None","Units Sold":"2518","Manufacturing Price":"10","Sale Price":"12","Gross Sales":"30216","Discounts":"0","Sales":"30216","COGS":"7554","Profit":"22662","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":20,"Segment":"Government","Country":"Germany","Product":"Paseo","Discount Band":"None","Units Sold":"1006","Manufacturing Price":"10","Sale Price":"350","Gross Sales":"352100","Discounts":"0","Sales":"352100","COGS":"261560","Profit":"90540","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":21,"Segment":"Channel Partners","Country":"Germany","Product":"Paseo","Discount Band":"None","Units Sold":"367","Manufacturing Price":"10","Sale Price":"12","Gross Sales":"4404","Discounts":"0","Sales":"4404","COGS":"1101","Profit":"3303","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":22,"Segment":"Government","Country":"Mexico","Product":"Paseo","Discount Band":"None","Units Sold":"883","Manufacturing Price":"10","Sale Price":"7","Gross Sales":"6181","Discounts":"0","Sales":"6181","COGS":"4415","Profit":"1766","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":23,"Segment":"Midmarket","Country":"France","Product":"Paseo","Discount Band":"None","Units Sold":"549","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"8235","Discounts":"0","Sales":"8235","COGS":"5490","Profit":"2745","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":24,"Segment":"Small Business","Country":"Mexico","Product":"Paseo","Discount Band":"None","Units Sold":"788","Manufacturing Price":"10","Sale Price":"300","Gross Sales":"236400","Discounts":"0","Sales":"236400","COGS":"197000","Profit":"39400","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":25,"Segment":"Midmarket","Country":"Mexico","Product":"Paseo","Discount Band":"None","Units Sold":"2472","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"37080","Discounts":"0","Sales":"37080","COGS":"24720","Profit":"12360","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":26,"Segment":"Government","Country":"United States of America","Product":"Paseo","Discount Band":"None","Units Sold":"1143","Manufacturing Price":"10","Sale Price":"7","Gross Sales":"8001","Discounts":"0","Sales":"8001","COGS":"5715","Profit":"2286","Date":"2014-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2014"},{"_id":27,"Segment":"Government","Country":"Canada","Product":"Paseo","Discount Band":"None","Units Sold":"1725","Manufacturing Price":"10","Sale Price":"350","Gross Sales":"603750","Discounts":"0","Sales":"603750","COGS":"448500","Profit":"155250","Date":"2013-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2013"},{"_id":28,"Segment":"Channel Partners","Country":"United States of America","Product":"Paseo","Discount Band":"None","Units Sold":"912","Manufacturing Price":"10","Sale Price":"12","Gross Sales":"10944","Discounts":"0","Sales":"10944","COGS":"2736","Profit":"8208","Date":"2013-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2013"},{"_id":29,"Segment":"Midmarket","Country":"Canada","Product":"Paseo","Discount Band":"None","Units Sold":"2152","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"32280","Discounts":"0","Sales":"32280","COGS":"21520","Profit":"10760","Date":"2013-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2013"},{"_id":30,"Segment":"Government","Country":"Canada","Product":"Paseo","Discount Band":"None","Units Sold":"1817","Manufacturing Price":"10","Sale Price":"20","Gross Sales":"36340","Discounts":"0","Sales":"36340","COGS":"18170","Profit":"18170","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":31,"Segment":"Government","Country":"Germany","Product":"Paseo","Discount Band":"None","Units Sold":"1513","Manufacturing Price":"10","Sale Price":"350","Gross Sales":"529550","Discounts":"0","Sales":"529550","COGS":"393380","Profit":"136170","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":32,"Segment":"Government","Country":"Mexico","Product":"Velo","Discount Band":"None","Units Sold":"1493","Manufacturing Price":"120","Sale Price":"7","Gross Sales":"10451","Discounts":"0","Sales":"10451","COGS":"7465","Profit":"2986","Date":"2014-01-01 00:00:00","Month Number":"1","Month Name":"January","Year":"2014"},{"_id":33,"Segment":"Enterprise","Country":"France","Product":"Velo","Discount Band":"None","Units Sold":"1804","Manufacturing Price":"120","Sale Price":"125","Gross Sales":"225500","Discounts":"0","Sales":"225500","COGS":"216480","Profit":"9020","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":34,"Segment":"Channel Partners","Country":"Germany","Product":"Velo","Discount Band":"None","Units Sold":"2161","Manufacturing Price":"120","Sale Price":"12","Gross Sales":"25932","Discounts":"0","Sales":"25932","COGS":"6483","Profit":"19449","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":35,"Segment":"Government","Country":"Germany","Product":"Velo","Discount Band":"None","Units Sold":"1006","Manufacturing Price":"120","Sale Price":"350","Gross Sales":"352100","Discounts":"0","Sales":"352100","COGS":"261560","Profit":"90540","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":36,"Segment":"Channel Partners","Country":"Germany","Product":"Velo","Discount Band":"None","Units Sold":"1545","Manufacturing Price":"120","Sale Price":"12","Gross Sales":"18540","Discounts":"0","Sales":"18540","COGS":"4635","Profit":"13905","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":37,"Segment":"Enterprise","Country":"United States of America","Product":"Velo","Discount Band":"None","Units Sold":"2821","Manufacturing Price":"120","Sale Price":"125","Gross Sales":"352625","Discounts":"0","Sales":"352625","COGS":"338520","Profit":"14105","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":38,"Segment":"Enterprise","Country":"Canada","Product":"Velo","Discount Band":"None","Units Sold":"345","Manufacturing Price":"120","Sale Price":"125","Gross Sales":"43125","Discounts":"0","Sales":"43125","COGS":"41400","Profit":"1725","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":39,"Segment":"Small Business","Country":"Canada","Product":"VTT","Discount Band":"None","Units Sold":"2001","Manufacturing Price":"250","Sale Price":"300","Gross Sales":"600300","Discounts":"0","Sales":"600300","COGS":"500250","Profit":"100050","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":40,"Segment":"Channel Partners","Country":"Germany","Product":"VTT","Discount Band":"None","Units Sold":"2838","Manufacturing Price":"250","Sale Price":"12","Gross Sales":"34056","Discounts":"0","Sales":"34056","COGS":"8514","Profit":"25542","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":41,"Segment":"Midmarket","Country":"France","Product":"VTT","Discount Band":"None","Units Sold":"2178","Manufacturing Price":"250","Sale Price":"15","Gross Sales":"32670","Discounts":"0","Sales":"32670","COGS":"21780","Profit":"10890","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":42,"Segment":"Midmarket","Country":"Germany","Product":"VTT","Discount Band":"None","Units Sold":"888","Manufacturing Price":"250","Sale Price":"15","Gross Sales":"13320","Discounts":"0","Sales":"13320","COGS":"8880","Profit":"4440","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":43,"Segment":"Government","Country":"France","Product":"VTT","Discount Band":"None","Units Sold":"1527","Manufacturing Price":"250","Sale Price":"350","Gross Sales":"534450","Discounts":"0","Sales":"534450","COGS":"397020","Profit":"137430","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":44,"Segment":"Small Business","Country":"France","Product":"VTT","Discount Band":"None","Units Sold":"2151","Manufacturing Price":"250","Sale Price":"300","Gross Sales":"645300","Discounts":"0","Sales":"645300","COGS":"537750","Profit":"107550","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":45,"Segment":"Government","Country":"Canada","Product":"VTT","Discount Band":"None","Units Sold":"1817","Manufacturing Price":"250","Sale Price":"20","Gross Sales":"36340","Discounts":"0","Sales":"36340","COGS":"18170","Profit":"18170","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":46,"Segment":"Government","Country":"France","Product":"Amarilla","Discount Band":"None","Units Sold":"2750","Manufacturing Price":"260","Sale Price":"350","Gross Sales":"962500","Discounts":"0","Sales":"962500","COGS":"715000","Profit":"247500","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":47,"Segment":"Channel Partners","Country":"United States of America","Product":"Amarilla","Discount Band":"None","Units Sold":"1953","Manufacturing Price":"260","Sale Price":"12","Gross Sales":"23436","Discounts":"0","Sales":"23436","COGS":"5859","Profit":"17577","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":48,"Segment":"Enterprise","Country":"Germany","Product":"Amarilla","Discount Band":"None","Units Sold":"4219.5","Manufacturing Price":"260","Sale Price":"125","Gross Sales":"527437.5","Discounts":"0","Sales":"527437.5","COGS":"506340","Profit":"21097.5","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":49,"Segment":"Government","Country":"France","Product":"Amarilla","Discount Band":"None","Units Sold":"1899","Manufacturing Price":"260","Sale Price":"20","Gross Sales":"37980","Discounts":"0","Sales":"37980","COGS":"18990","Profit":"18990","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":50,"Segment":"Government","Country":"Germany","Product":"Amarilla","Discount Band":"None","Units Sold":"1686","Manufacturing Price":"260","Sale Price":"7","Gross Sales":"11802","Discounts":"0","Sales":"11802","COGS":"8430","Profit":"3372","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":51,"Segment":"Channel Partners","Country":"United States of America","Product":"Amarilla","Discount Band":"None","Units Sold":"2141","Manufacturing Price":"260","Sale Price":"12","Gross Sales":"25692","Discounts":"0","Sales":"25692","COGS":"6423","Profit":"19269","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":52,"Segment":"Government","Country":"United States of America","Product":"Amarilla","Discount Band":"None","Units Sold":"1143","Manufacturing Price":"260","Sale Price":"7","Gross Sales":"8001","Discounts":"0","Sales":"8001","COGS":"5715","Profit":"2286","Date":"2014-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2014"},{"_id":53,"Segment":"Midmarket","Country":"United States of America","Product":"Amarilla","Discount Band":"None","Units Sold":"615","Manufacturing Price":"260","Sale Price":"15","Gross Sales":"9225","Discounts":"0","Sales":"9225","COGS":"6150","Profit":"3075","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":54,"Segment":"Government","Country":"France","Product":"Paseo","Discount Band":"Low","Units Sold":"3945","Manufacturing Price":"10","Sale Price":"7","Gross Sales":"27615","Discounts":"276.15","Sales":"27338.850000000002","COGS":"19725","Profit":"7613.850000000002","Date":"2014-01-01 00:00:00","Month Number":"1","Month Name":"January","Year":"2014"},{"_id":55,"Segment":"Midmarket","Country":"France","Product":"Paseo","Discount Band":"Low","Units Sold":"2296","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"34440","Discounts":"344.4","Sales":"34095.6","COGS":"22960","Profit":"11135.599999999999","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":56,"Segment":"Government","Country":"France","Product":"Paseo","Discount Band":"Low","Units Sold":"1030","Manufacturing Price":"10","Sale Price":"7","Gross Sales":"7210","Discounts":"72.1","Sales":"7137.9","COGS":"5150","Profit":"1987.8999999999996","Date":"2014-05-01 00:00:00","Month Number":"5","Month Name":"May","Year":"2014"},{"_id":57,"Segment":"Government","Country":"France","Product":"Velo","Discount Band":"Low","Units Sold":"639","Manufacturing Price":"120","Sale Price":"7","Gross Sales":"4473","Discounts":"44.73","Sales":"4428.27","COGS":"3195","Profit":"1233.2700000000004","Date":"2014-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2014"},{"_id":58,"Segment":"Government","Country":"Canada","Product":"VTT","Discount Band":"Low","Units Sold":"1326","Manufacturing Price":"250","Sale Price":"7","Gross Sales":"9282","Discounts":"92.82","Sales":"9189.18","COGS":"6630","Profit":"2559.1800000000003","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":59,"Segment":"Channel Partners","Country":"United States of America","Product":"Carretera","Discount Band":"Low","Units Sold":"1858","Manufacturing Price":"3","Sale Price":"12","Gross Sales":"22296","Discounts":"222.96","Sales":"22073.04","COGS":"5574","Profit":"16499.04","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":60,"Segment":"Government","Country":"Mexico","Product":"Carretera","Discount Band":"Low","Units Sold":"1210","Manufacturing Price":"3","Sale Price":"350","Gross Sales":"423500","Discounts":"4235","Sales":"419265","COGS":"314600","Profit":"104665","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":61,"Segment":"Government","Country":"United States of America","Product":"Carretera","Discount Band":"Low","Units Sold":"2529","Manufacturing Price":"3","Sale Price":"7","Gross Sales":"17703","Discounts":"177.03","Sales":"17525.97","COGS":"12645","Profit":"4880.969999999999","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":62,"Segment":"Channel Partners","Country":"Canada","Product":"Carretera","Discount Band":"Low","Units Sold":"1445","Manufacturing Price":"3","Sale Price":"12","Gross Sales":"17340","Discounts":"173.4","Sales":"17166.6","COGS":"4335","Profit":"12831.599999999999","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":63,"Segment":"Enterprise","Country":"United States of America","Product":"Carretera","Discount Band":"Low","Units Sold":"330","Manufacturing Price":"3","Sale Price":"125","Gross Sales":"41250","Discounts":"412.5","Sales":"40837.5","COGS":"39600","Profit":"1237.5","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":64,"Segment":"Channel Partners","Country":"France","Product":"Carretera","Discount Band":"Low","Units Sold":"2671","Manufacturing Price":"3","Sale Price":"12","Gross Sales":"32052","Discounts":"320.52","Sales":"31731.48","COGS":"8013","Profit":"23718.48","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":65,"Segment":"Channel Partners","Country":"Germany","Product":"Carretera","Discount Band":"Low","Units Sold":"766","Manufacturing Price":"3","Sale Price":"12","Gross Sales":"9192","Discounts":"91.92","Sales":"9100.08","COGS":"2298","Profit":"6802.08","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":66,"Segment":"Small Business","Country":"Mexico","Product":"Carretera","Discount Band":"Low","Units Sold":"494","Manufacturing Price":"3","Sale Price":"300","Gross Sales":"148200","Discounts":"1482","Sales":"146718","COGS":"123500","Profit":"23218","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":67,"Segment":"Government","Country":"Mexico","Product":"Carretera","Discount Band":"Low","Units Sold":"1397","Manufacturing Price":"3","Sale Price":"350","Gross Sales":"488950","Discounts":"4889.5","Sales":"484060.5","COGS":"363220","Profit":"120840.5","Date":"2014-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2014"},{"_id":68,"Segment":"Government","Country":"France","Product":"Carretera","Discount Band":"Low","Units Sold":"2155","Manufacturing Price":"3","Sale Price":"350","Gross Sales":"754250","Discounts":"7542.5","Sales":"746707.5","COGS":"560300","Profit":"186407.5","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":69,"Segment":"Midmarket","Country":"Mexico","Product":"Montana","Discount Band":"Low","Units Sold":"2214","Manufacturing Price":"5","Sale Price":"15","Gross Sales":"33210","Discounts":"332.1","Sales":"32877.9","COGS":"22140","Profit":"10737.900000000001","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":70,"Segment":"Small Business","Country":"United States of America","Product":"Montana","Discount Band":"Low","Units Sold":"2301","Manufacturing Price":"5","Sale Price":"300","Gross Sales":"690300","Discounts":"6903","Sales":"683397","COGS":"575250","Profit":"108147","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":71,"Segment":"Government","Country":"France","Product":"Montana","Discount Band":"Low","Units Sold":"1375.5","Manufacturing Price":"5","Sale Price":"20","Gross Sales":"27510","Discounts":"275.1","Sales":"27234.899999999998","COGS":"13755","Profit":"13479.899999999998","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":72,"Segment":"Government","Country":"Canada","Product":"Montana","Discount Band":"Low","Units Sold":"1830","Manufacturing Price":"5","Sale Price":"7","Gross Sales":"12810","Discounts":"128.1","Sales":"12681.9","COGS":"9150","Profit":"3531.8999999999996","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":73,"Segment":"Small Business","Country":"United States of America","Product":"Montana","Discount Band":"Low","Units Sold":"2498","Manufacturing Price":"5","Sale Price":"300","Gross Sales":"749400","Discounts":"7494","Sales":"741906","COGS":"624500","Profit":"117406","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":74,"Segment":"Enterprise","Country":"United States of America","Product":"Montana","Discount Band":"Low","Units Sold":"663","Manufacturing Price":"5","Sale Price":"125","Gross Sales":"82875","Discounts":"828.75","Sales":"82046.25","COGS":"79560","Profit":"2486.25","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":75,"Segment":"Midmarket","Country":"United States of America","Product":"Paseo","Discount Band":"Low","Units Sold":"1514","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"22710","Discounts":"227.1","Sales":"22482.9","COGS":"15140","Profit":"7342.9000000000015","Date":"2014-02-01 00:00:00","Month Number":"2","Month Name":"February","Year":"2014"},{"_id":76,"Segment":"Government","Country":"United States of America","Product":"Paseo","Discount Band":"Low","Units Sold":"4492.5","Manufacturing Price":"10","Sale Price":"7","Gross Sales":"31447.5","Discounts":"314.475","Sales":"31133.024999999998","COGS":"22462.5","Profit":"8670.524999999998","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":77,"Segment":"Enterprise","Country":"United States of America","Product":"Paseo","Discount Band":"Low","Units Sold":"727","Manufacturing Price":"10","Sale Price":"125","Gross Sales":"90875","Discounts":"908.75","Sales":"89966.25","COGS":"87240","Profit":"2726.25","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":78,"Segment":"Enterprise","Country":"France","Product":"Paseo","Discount Band":"Low","Units Sold":"787","Manufacturing Price":"10","Sale Price":"125","Gross Sales":"98375","Discounts":"983.75","Sales":"97391.25","COGS":"94440","Profit":"2951.25","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":79,"Segment":"Enterprise","Country":"Mexico","Product":"Paseo","Discount Band":"Low","Units Sold":"1823","Manufacturing Price":"10","Sale Price":"125","Gross Sales":"227875","Discounts":"2278.75","Sales":"225596.25","COGS":"218760","Profit":"6836.25","Date":"2014-07-01 00:00:00","Month Number":"7","Month Name":"July","Year":"2014"},{"_id":80,"Segment":"Midmarket","Country":"Germany","Product":"Paseo","Discount Band":"Low","Units Sold":"747","Manufacturing Price":"10","Sale Price":"15","Gross Sales":"11205","Discounts":"112.05","Sales":"11092.95","COGS":"7470","Profit":"3622.9500000000007","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":81,"Segment":"Channel Partners","Country":"Germany","Product":"Paseo","Discount Band":"Low","Units Sold":"766","Manufacturing Price":"10","Sale Price":"12","Gross Sales":"9192","Discounts":"91.92","Sales":"9100.08","COGS":"2298","Profit":"6802.08","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":82,"Segment":"Small Business","Country":"United States of America","Product":"Paseo","Discount Band":"Low","Units Sold":"2905","Manufacturing Price":"10","Sale Price":"300","Gross Sales":"871500","Discounts":"8715","Sales":"862785","COGS":"726250","Profit":"136535","Date":"2014-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2014"},{"_id":83,"Segment":"Government","Country":"France","Product":"Paseo","Discount Band":"Low","Units Sold":"2155","Manufacturing Price":"10","Sale Price":"350","Gross Sales":"754250","Discounts":"7542.5","Sales":"746707.5","COGS":"560300","Profit":"186407.5","Date":"2014-12-01 00:00:00","Month Number":"12","Month Name":"December","Year":"2014"},{"_id":84,"Segment":"Government","Country":"France","Product":"Velo","Discount Band":"Low","Units Sold":"3864","Manufacturing Price":"120","Sale Price":"20","Gross Sales":"77280","Discounts":"772.8000000000001","Sales":"76507.20000000001","COGS":"38640","Profit":"37867.200000000004","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":85,"Segment":"Government","Country":"Mexico","Product":"Velo","Discount Band":"Low","Units Sold":"362","Manufacturing Price":"120","Sale Price":"7","Gross Sales":"2534","Discounts":"25.34","Sales":"2508.66","COGS":"1810","Profit":"698.6599999999999","Date":"2014-05-01 00:00:00","Month Number":"5","Month Name":"May","Year":"2014"},{"_id":86,"Segment":"Enterprise","Country":"Canada","Product":"Velo","Discount Band":"Low","Units Sold":"923","Manufacturing Price":"120","Sale Price":"125","Gross Sales":"115375","Discounts":"1153.75","Sales":"114221.25","COGS":"110760","Profit":"3461.25","Date":"2014-08-01 00:00:00","Month Number":"8","Month Name":"August","Year":"2014"},{"_id":87,"Segment":"Enterprise","Country":"United States of America","Product":"Velo","Discount Band":"Low","Units Sold":"663","Manufacturing Price":"120","Sale Price":"125","Gross Sales":"82875","Discounts":"828.75","Sales":"82046.25","COGS":"79560","Profit":"2486.25","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":88,"Segment":"Government","Country":"Canada","Product":"Velo","Discount Band":"Low","Units Sold":"2092","Manufacturing Price":"120","Sale Price":"7","Gross Sales":"14644","Discounts":"146.44","Sales":"14497.56","COGS":"10460","Profit":"4037.5599999999995","Date":"2013-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2013"},{"_id":89,"Segment":"Government","Country":"Germany","Product":"VTT","Discount Band":"Low","Units Sold":"263","Manufacturing Price":"250","Sale Price":"7","Gross Sales":"1841","Discounts":"18.41","Sales":"1822.59","COGS":"1315","Profit":"507.5899999999999","Date":"2014-03-01 00:00:00","Month Number":"3","Month Name":"March","Year":"2014"},{"_id":90,"Segment":"Government","Country":"Canada","Product":"VTT","Discount Band":"Low","Units Sold":"943.5","Manufacturing Price":"250","Sale Price":"350","Gross Sales":"330225","Discounts":"3302.25","Sales":"326922.75","COGS":"245310","Profit":"81612.75","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":91,"Segment":"Enterprise","Country":"United States of America","Product":"VTT","Discount Band":"Low","Units Sold":"727","Manufacturing Price":"250","Sale Price":"125","Gross Sales":"90875","Discounts":"908.75","Sales":"89966.25","COGS":"87240","Profit":"2726.25","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":92,"Segment":"Enterprise","Country":"France","Product":"VTT","Discount Band":"Low","Units Sold":"787","Manufacturing Price":"250","Sale Price":"125","Gross Sales":"98375","Discounts":"983.75","Sales":"97391.25","COGS":"94440","Profit":"2951.25","Date":"2014-06-01 00:00:00","Month Number":"6","Month Name":"June","Year":"2014"},{"_id":93,"Segment":"Small Business","Country":"Germany","Product":"VTT","Discount Band":"Low","Units Sold":"986","Manufacturing Price":"250","Sale Price":"300","Gross Sales":"295800","Discounts":"2958","Sales":"292842","COGS":"246500","Profit":"46342","Date":"2014-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2014"},{"_id":94,"Segment":"Small Business","Country":"Mexico","Product":"VTT","Discount Band":"Low","Units Sold":"494","Manufacturing Price":"250","Sale Price":"300","Gross Sales":"148200","Discounts":"1482","Sales":"146718","COGS":"123500","Profit":"23218","Date":"2013-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2013"},{"_id":95,"Segment":"Government","Country":"Mexico","Product":"VTT","Discount Band":"Low","Units Sold":"1397","Manufacturing Price":"250","Sale Price":"350","Gross Sales":"488950","Discounts":"4889.5","Sales":"484060.5","COGS":"363220","Profit":"120840.5","Date":"2014-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2014"},{"_id":96,"Segment":"Enterprise","Country":"France","Product":"VTT","Discount Band":"Low","Units Sold":"1744","Manufacturing Price":"250","Sale Price":"125","Gross Sales":"218000","Discounts":"2180","Sales":"215820","COGS":"209280","Profit":"6540","Date":"2014-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2014"},{"_id":97,"Segment":"Channel Partners","Country":"United States of America","Product":"Amarilla","Discount Band":"Low","Units Sold":"1989","Manufacturing Price":"260","Sale Price":"12","Gross Sales":"23868","Discounts":"238.68","Sales":"23629.32","COGS":"5967","Profit":"17662.32","Date":"2013-09-01 00:00:00","Month Number":"9","Month Name":"September","Year":"2013"},{"_id":98,"Segment":"Midmarket","Country":"France","Product":"Amarilla","Discount Band":"Low","Units Sold":"321","Manufacturing Price":"260","Sale Price":"15","Gross Sales":"4815","Discounts":"48.15","Sales":"4766.85","COGS":"3210","Profit":"1556.8500000000004","Date":"2013-11-01 00:00:00","Month Number":"11","Month Name":"November","Year":"2013"},{"_id":99,"Segment":"Enterprise","Country":"Canada","Product":"Carretera","Discount Band":"Low","Units Sold":"742.5","Manufacturing Price":"3","Sale Price":"125","Gross Sales":"92812.5","Discounts":"1856.25","Sales":"90956.25","COGS":"89100","Profit":"1856.25","Date":"2014-04-01 00:00:00","Month Number":"4","Month Name":"April","Year":"2014"},{"_id":100,"Segment":"Channel Partners","Country":"Canada","Product":"Carretera","Discount Band":"Low","Units Sold":"1295","Manufacturing Price":"3","Sale Price":"12","Gross Sales":"15540","Discounts":"310.8","Sales":"15229.2","COGS":"3885","Profit":"11344.2","Date":"2014-10-01 00:00:00","Month Number":"10","Month Name":"October","Year":"2014"}], "fields": [{"id": "_id", "type": "int"}, {"id": "Segment", "type": "text"}, {"id": "Country", "type": "text"}, {"id": "Product", "type": "text"}, {"id": "Discount Band", "type": "text"}, {"id": "Units Sold", "type": "text"}, {"id": "Manufacturing Price", "type": "text"}, {"id": "Sale Price", "type": "text"}, {"id": "Gross Sales", "type": "text"}, {"id": "Discounts", "type": "text"}, {"id": "Sales", "type": "text"}, {"id": "COGS", "type": "text"}, {"id": "Profit", "type": "text"}, {"id": "Date", "type": "text"}, {"id": "Month Number", "type": "text"}, {"id": "Month Name", "type": "text"}, {"id": "Year", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=adf6b866-e57c-4ed9-aecd-a5f566ebbb2e", "next": "/api/action/datastore_search?resource_id=adf6b866-e57c-4ed9-aecd-a5f566ebbb2e&offset=100"}, "total": 700, "total_was_estimated": false}}