community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Average number of "something" until "something else"

Asteroid

Hello,

 

Can anyone help me or provide direction creating two calculations (average number of calls until an appointment) and (running average calls until an appointment)? Attaching an Excel snippet of the data and desired results.

 

thanks,

Matt

Highlighted
Alteryx Partner

In order to calculate these statistics correctly I have assumed that your data will have to identify for each call:

 

Caller ID 

Appointment Date

Date of call

 

To get a true average you will also have to account for 

 

Appointments where no calls are made

Calls that result in a cancellation and a new appointment date

Calls that result in a cancellation and no appointment

Callers that have multiple future appointments scheduled

 

Using your data with some modifications I have created a simple model that will give you a starting point for building your production model.

 

 

2018-02-25_00010.png

 

 

 

 

 

 

Pulsar

Give the attached a shot, see if it gets you what you need:

image.png

Asteroid

@danrh that's exactly what I was looking for. thanks!

Labels