Remove time and extract from accumulative values

[Adolfo]

Hello,

There is a table with accumulative data taken every 15 minutes. I would need to get the values only on the hour (not 15, 30 or 45 min).

Besides, I would need to substract one value from its previous one, so I could get the real value every hour from the accumulated.

Example:

1. Original table:

         DateTime                AccumulativeValue             

01/04/2020  06:00:06                  2

01/04/2020  06:15:06                  4

01/04/2020  06:30:06                  5

01/04/2020  06:45:06                  15

01/04/2020  07:00:06                  16

01/04/2020  07:15:06                  18

01/04/2020  07:30:06                  19

01/04/2020  07:45:06                  23

01/04/2020  08:00:06                  25

01/04/2020  08:15:06                  28

01/04/2020  08:30:06                  31

01/04/2020  08:45:06                  32

01/04/2020  09:00:06                  37

01/04/2020  09:15:06                  41

etc

2. Final table:

          DateTime               AccumulativeValue            RealValue    

01/04/2020  06:00:06                 2                                (null)

01/04/2020  07:00:06                 16                                14

01/04/2020  08:00:06                  25                                9

01/04/2020  09:00:06                  37                               12

etc

Thank you!!!

Adolfo

[grossal · Accepted solution]

Hi @Adolfo,

here is a quick way to do this:

Result:

What happens:

- DateTime Conversion to have an actual DateTime object (DateTime)

- Renaming and reordering (Select) 

- Multi-Row-Formula for grouping 

- Summarize with Group by and First 

- Multi-Row Formula for RealValue

Workflow attached. Let me know what you think.

Best

Alex

[Adolfo]

Thank you very much!!! It works perfectly!