how to group by specific timestamp interval like 15 min?????

[numpsy b]

If I have data from 8-22 each day and i want to separate it to 3 h he separate this way: var result = from tick in listTicks group tick by new { Hour=tick.Day ,ThreeHours=( ??? ) } into g select new { Count = g.Count(), Key = g.Key, Items = g }; normally it will seperated this way 0-2;3-5;6-8;9-11,... , but i want it 8-10;11-13;14-16;17-19;20-22 how can i this manage...?

[J4amieC]

Im a bit exasperated you couldn't figure this out yourself with the help already given, however your problem is a simple one still. Group by the number of hours past 8 in blocks of 3 hours.

var result = from tick in listTicks
group tick by new { HoursPastEight = (3*Math.Floor((double)((tick.Hour-8) / 3))) } into g
select new
{
Count = g.Count(),
Key = g.Key,
Items = g
};

[numpsy b]

is it possible to have access to the last g during creating the select new { } i want to check an actual value withe one from the last g

[J4amieC]

Ive now provided you the very best help you're ever likely to get, and you've not even seen fit to type the words "thank you" even once, im now done helping you. You're not going to get spoon-fed in this industry, I provided you some workable examples hoping you would have a little play around yourself. Youve not. You've simply asked another mindless question. Good day sir.

[ABitSmart]

Thank you :) (although I voted you 5 earlier, wanted to give it a 555) (Makes me feel guilty for not leaving the thank you note earlier)

[numpsy b]

hey i only can say thank you... thatsy why i pushed shortly directly on the first answer a positive reputation... i voted positive and thoughty thats what i have to do... sry that i dont said it directly... but your help was undoubtedly great! anyway do you know something about teh access?

[J4amieC]

Well, how about you have a try at solving your problem, and if you get stuck post the code you're up to.

[numpsy b]

        var result3 = (from tick in listTicks
                       group tick by new { Day = tick.timestamp.Day, HoursPastEight = (3 \* Math.Floor(Convert.ToDouble((tick.timestamp.Hour - 8) / 3))) } into g
                       select g).Select(g => 
                       {
                           // Create your object with the last timestamp
                           var runtimeResult = new
                           { 
                               Count = g.Count(),
                               //Key = g.Key, 
                               Items = g,
                               Timestamp = g.First().timestamp,
                               LastTimestamp = lastTimestamp
                           };

                           // Set last timestamp for next iteration
                           lastTimestamp = runtimeResult.Timestamp;

                           // Return your object
                           return result;
                       });

but this wont't work because in debug i dont find Count , Items, Timestamp, LastTimestamp etc...

[numpsy b]

var lastTimestamp = new DateTime(1970, 1, 1);

is also needed... for the first round

[numpsy b]

the fault is result.Timestamp -> has to be g... then it works