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

Average number of "something" until "something else"

mattlukoff
8 - 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

3 REPLIES 3
derekbelyea
12 - Quasar

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

 

 

 

 

 

 

danrh
13 - Pulsar

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

image.png

mattlukoff
8 - Asteroid

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

Labels