如何在jquery中整合xml数据？

Here's what I want to do. I have a big xml file (there are a lot of daily records... let's say for every 3 hours there are some production records (pieces, scrap and so on). Now... I parse this XML in jQuery and I want to put the data in a jqGrid then show it as a chart with highcharts. The problem is that I don't want to show every record... just the daily results or weekly or monthly so what I need is to sum up all those 3 hour reports by date or by week or by month. I know how to do it... but since there are a lot of records looping through the xml multiple times is not the best idea. So... is there any jquery function or something that will help me do this task more efficient? Or easier? Thanks! If you didn't understand what I want please ask and I'll add more details.Here's what I want to do. I have a big xml file