Hello,
There is a table with a large amount of values taken every 15min. I would like to sum them in order to obtain one value per hour.
For example, the original table is:
DATE VALUE
2020-04-01 06:00:14 15
2020-04-01 06:15:14 20
2020-04-01 06:30:14 05
2020-04-01 06:45:14 10
2020-04-01 07:00:14 15
2020-04-01 07:15:14 20
2020-04-01 07:30:14 10
2020-04-01 07:45:14 30
etc
The result could be something like this (although the null values are no longer needed):
DATE VALUE SUM
2020-04-01 06:00:14 15 50
2020-04-01 06:15:14 20 null
2020-04-01 06:30:14 05 null
2020-04-01 06:45:14 10 null
2020-04-01 07:00:14 15 75
2020-04-01 07:15:14 20 null
2020-04-01 07:30:14 10 null
2020-04-01 07:45:14 30 null
etc
I would like to remove the null values, so that the final result could be:
DATE VALUE SUM
2020-04-01 06:00:14 15 50
2020-04-01 07:00:14 15 75
etc
Is it possible? I'm a new Alteryx user and I've trying for hours with no success.
Thanks in advance!
Adolfo
