Tuesday, 15 May 2012

Group by key in crossfilter data in table structure. I do not need the chart -


I have a large group of more than 5 million records. I have managed to draw the data structure as a crossfilter in the table structure. Now I want to group data using the symbol key. Any help would be appreciated.

This is my code

  d3.json ("my_json_file.json", function (error, json_data) {var data = crossfilter (json_data), typidim = stock_jonix cdmimon (Function (D) {Return DIMBOL;}) Type Group = Type Radius Group () All (); $ ('# steak_table'). DataTable ({"AAdata": Type Dimension {"MDataProp": " {"MDataProp": "symbol"}, {"mDataProp": "stock_name"}, {"mDataProp": "changepent"}, {"MDataProp": "off"}, {"mDataProp": " Volume "}]});});  

Some of the contents of my JSN file are given here:

  [{"id": "11", "symbol": "01 kg" "0", "Closed": "125.00", "Closed": "", "Symbol": "63", "Symbol": "Scottish American Investment Company Plc", "Convertible": "125.00", " "Scottish American investment company PLC", "change": "", "0", "0", "quantity": "0"}, "id": "64", "1", "stock_name": " "", "Close": "125.00", "Volume" "Symbol": "01OO", "Stock_name": "Nordic Investment Bank 5.25% NTS 26/11/19", "ChangeFentant": "- 0.532", "Closed": "118.30", "Volume": "2000"}, {"id": "65", "symbol": "01OO", "stock_name": "Nordic Investment Bank 5.25% NTS 26/11 / "", "Symbol": "01OO", "stock_name": "", "Change": "-" "Change": "- 0.264" "Off": "118.93", "Volume": "6000"}, {"id": "66", " Nordic Investment Bank 5.25% NTS 26 \ / 11 \ /19 ,,changes: - " "", "Close": "118.33", "Volume": "3000": "01o", "stock_name": "Nordic Investment Bank 5.25% NTS 26 \ / 11 \ / 19", "ChangePaint": "1.747", "Close" }, {"Id": "68" "symbol": "01OO", "stock_name": "Nordic Investments Bank 5.25% NTS 26 \ / 11 \ "9" "" "" "" "" "" "" "" "" "": "0", "Closed" "" "British land" plc "," convertible ":" 0 "," "," 10000000 "}," "," id ":" 69 "," symbol ":" 04LL "," stock_name " "Barclays Bank PLC 9% Perm In Brig Cap BDS #": "Close": "115.00", "Quantity": "0"}, {"id": "132", "Symbol": "06GH", "stock_name" "", "" "", "" "", "" "", "", "" "", " Barclays Bank PLC 9% Perm In Brig Cap BDS # "," ChangePaint ":" 0.412 "," Close ":" 122.00 "," Volume ":" 0 "} "ADG": "160", "symbol": "06GH", "stock_name": "Barclays bank plc 9% perm in brig cap bds #", "changepictant": "0", "close": "121.50" "Volume": "0"}, {"id": "179", "symbol": "06GH", "stock_name": "Barclays bank plc 9% perm in brig cap bds #", "changefront": "0 "", "Closed": "119.50", "Volume": "0"}, {"id": "180", "symbol": "06GH", "stock_name": "Barclays bank plc 9% permite brag Cap "BGS #", "ChangePartent": "- 3.239", "Close": "119.50", "Volume": "6000"}, {"id": "181", "Symbol": "06 GH "," stock_name ":" Barclays bank plc 9% perm in brig cap BDS # "," changepaint ":" 0 "," close ":" 123.50 "," volume ":" 0 "}, {" "" "", "Symbol": "06GH", "stock_name": "Barclays bank plc 9% perm in brig cap BDS #", "change", "" "," closed ":" 121.50 " "Bar": "0", "Closed": "121.50", "Void": "0", "Closet" "Volume": "0"}, {"id": "193", "Symbol": "06GH", "Paint In Brig Cap BDS #", "ChangePrescent": "0" "Stock_name": "Bar "College", " "0", "symbol": "0", "symbol": "06GH", "stock_name": "Barclays bank plc 9% perm in brig cap bds #", "changepicture": "0" "6", "stock_name": "Hemingway debenture LD", "0", "closed": "130.00", "Volume": "", "" "1921", "symbol": "06HB" "0", "0", "Closed", "0", "Closed": "130", "Volume", "0", "0", "0", "{0}", "0", " Symbol ":" 228 "," Symbol ":" 06 Hb "," Stock_name ":" Heming Ve debentures LD "": "0"}]  


No comments:

Post a Comment