Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Question

rrahu07
8 - Asteroid

How can I find the average of each day's run time?

rrahu07_1-1648737062058.png

 

 

I tried using sum tool to get the average. My question is, is there any formula that I can use so that I can get average for each day by each department. because when I use the sum tool it does not separate the days. it just sum up the entire population

 

7 REPLIES 7
binuacs
20 - Arcturus

@rrahu07 can you upload your sample data?

danilang
19 - Altair
19 - Altair

Hi @rrahu07 

 

Add in a formula tool to create a new field to extract just the date from your [Start Datetime] field using ToDate().  Add this new field as a grouping option in your Summarize tool.

 

Dan 

rrahu07
8 - Asteroid
binuacs
20 - Arcturus

@rrahu07 

binuacs_0-1648739642285.png

 

rrahu07
8 - Asteroid

@binuacs that worked. Another question, what should I do to get average between two run times and also making sure I am not including one days last with next days first? 

binuacs
20 - Arcturus

@rrahu07 not sure you are looking for something like this, if not please provide me the expected result

 

binuacs_0-1648765053564.png

 

rrahu07
8 - Asteroid

it worked. Thanks for your help @binuacs 

Labels