Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Remove time and extract from accumulative values

Highlighted
6 - Meteoroid

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

Highlighted
14 - Magnetar

Hi @Adolfo,

 

here is a quick way to do this:

grossal_1-1587814641759.png

 

 

Result:

grossal_0-1587815755695.png

 

 

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

Highlighted
6 - Meteoroid

Thank you very much!!! It works perfectly!

Labels