Alteryx Designer Desktop Discussions

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

How to calculate an average of a data base for previous week

grromerro
7 - Meteor

Hi Community,

 

I need your help please. I created a workflow that calculate the average of prices from Monday to Friday of the prior week from today (despite the day of the week I am running the workflow). However, I feel my solution has so many steps and I want to find a way to simplify it. I wonder if any of you knows a formula that can calculate the average in one shot. Attached an example of what I need to get. Thank you so much!

 

 

GRomero

1 REPLY 1
binuacs
20 - Arcturus

@grromerro one way of doing this

image.png

Labels