Alteryx Designer Desktop Discussions

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

Average

kaverijaiswal
6 - Meteoroid

Hi,

 

How to calculate the average of the following data sets in the below column. I tried using text to column tool to separate data into different column but I am not sure whether it's correct way to calculate average. Please advice.

 

Length of Appointments
51
59,46
46,55,67,49,60
71,62
40,61,65
70,31,61
57,58,41
62,43
67,32
43,46
45
35,45
49
53,27,51
66,69,48
63,50
54
73
36,48
42,70,47
51
65,75,33,53,58
32,56,63
41,34,62
49,74,73
47,36
68,37,58
32

 

Thanks,

Kaveri Jaiswal

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @kaverijaiswal ,

 

I'm attaching an example showing how to do average by line and also for all column.

 

Best,

Fernando Vizcaino

ponraj
13 - Pulsar

Here is my solution. 

Capture.PNG

kaverijaiswal
6 - Meteoroid

@ponraj @fmvizcaino 

 

Thank you both. Your solution worked seamlessly. 

Teckydoo
5 - Atom

This was very helpful. Using the browse tool was the fastest way for me. 

Labels