Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Hourly Sum of Data

    ChrisM@Work - Wednesday, September 6, 2017 8:17 AM

    madcloud97 - Wednesday, September 6, 2017 2:00 AM

    September 6, 2017 at 9:54 pm

    #1958480

  • RE: Hourly Sum of Data

    ChrisM@Work - Wednesday, September 6, 2017 1:30 AM

    madcloud97 - Tuesday, September 5, 2017 6:18 PM

    September 6, 2017 at 2:00 am

    #1958282

  • RE: Hourly Sum of Data

    Test result as below. Attached also excel for easy view.
    Correct me if I'm wrong, row 79 (from excel, also same thing happened for row 158), the HourStart &...

    September 6, 2017 at 1:43 am

    #1958278

  • RE: Hourly Sum of Data

    Sorry for the data error, @Chris.
    I will double check again the sample data I posted.

    Edited note: OP updated. I'm very sorry for the data...

    September 5, 2017 at 6:18 pm

    #1958244

  • RE: Hourly Sum of Data

    Avi1 - Tuesday, September 5, 2017 8:58 AM

    It is a data issue, please analyze. the date for that record is "2017-04-24 16:05:38.000"...

    September 5, 2017 at 6:11 pm

    #1958240

  • RE: Hourly Sum of Data

    Sorry for very late response as I outstation for 2 months. Result as below. I also included excel file for easy view. From the result, row 79 (read from excel),...

    September 5, 2017 at 2:31 am

    #1958048

  • RE: Hourly Sum of Data

    ChrisM@Work - Monday, July 24, 2017 5:15 AM

    Ok, next step is to join your data table to this hourly breakdown table. Try...

    July 24, 2017 at 7:58 pm

    #1952486

  • RE: Hourly Sum of Data

    Hi @ChrisM@Work, tested your query, it fits the "hour buckets" I required. Result below:

    July 23, 2017 at 9:38 pm

    #1952292

  • RE: Hourly Sum of Data

    Thanks @ChrisM@Work for the head start code. I will study and work from there.

    July 19, 2017 at 6:11 pm

    #1951774

Viewing 9 posts - 1 through 9 (of 9 total)