.net group by 时间段(年月日) - zLulus/My_Note GitHub Wiki
按日统计
var result = (from d in yourData
group d by new
{
time = new { d.CreationTime.Year, d.CreationTime.Month, d.CreationTime.Day }
} into g
select new
{
Value = g.Average(p => p.Value),
CreationTime = g.Key.time.Year + "-" + g.Key.time.Month + "-" + g.Key.time.Day
}).ToList();
按月统计
var result = (from d in yourData
group d by new
{
time = new { d.CreationTime.Year, d.CreationTime.Month }
} into g
select new
{
Value = g.Average(p => p.Value),
CreationTime = g.Key.time.Year + "-" + g.Key.time.Month
}).ToList();
其他的以此类推