Post reply

Query Sum the previous data based on date time stamp

  • October 25, 2014 at 7:37 am

    #312481

    Experts !

    I need to query data on time stamp example I have date with time stamp 2014-10-01 00:00:00 , 2014-10-01 01:00:00,2014-10-01 02:00:00.

    In the attached picture I have three columns 1. date with time, 2. Data and 3. calculated.

    2. The data is based on date time. I need on every hour the query minus the current hour value with previous hour value.

    Hope I understand well ! Sorry

    The picture is attached

  • October 25, 2014 at 7:51 am

    #1754770

    Even with the picture I'm not sure what it is you want exactly.

    Also, it may help if you provided more information including what you have tried so far. I would suggest you start by reading the first article I reference below in my signature block. It will walk you through what you should post and how to post it to get the best possible answers.

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

You must be logged in to reply to this topic. Login to reply