Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

5 minute to 15 minute interval data conversion

marlylove
7 - Meteor

Hi, I have pricing data that I get in 5 minutes intervals.  I need to convert this pricing data to a 15 minute average.  It looks like below.  

 

marlylove_0-1621882134774.png

 

Basically I'm trying to create column C below that is an average price per 15 minutes.  How can I do this in Alteryx?

marlylove_1-1621882302123.png

 

 

10 REPLIES 10
marlylove
7 - Meteor

So after I have the 15 minute average prices, how do I filter it to just so those prices?  

 

Nevermind, I figured this out.

 

Thanks for the help!

Labels
Top Solution Authors