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
Solved! Go to 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
Thank you very much!!! It works perfectly!