2 Replies Latest reply on Nov 3, 2016 2:40 PM by Yuriy Fal

# Correlation between 2 sources

dear all, I am trying to do a correlation between the turnup rate vs  number of days between online registered date and actual date registered attached on separate sheets.

Turnup: number of people who registered and turn up

NS: no show

A: came

registered =NS+A

Turn up rate = A/(NS+A) x 100% -> can be x or y axis

Worksheet 2

Registered Date

Test Date

Waiting duration between Registered Date and test date = Registered Date- Testdate (days)

can you help as I cannot seem to figure out any line...

thanks for your kind help fellow tableaurs!

rgds

Kris

• ###### 1. Re: Correlation between 2 sources

Calling for the community on this one.

kris goh require your amazing skills! Will you be the hero of his day?

• ###### 2. Re: Correlation between 2 sources

Hi Kris,

I'd like to help. What I couldn't figure out:

-- There are duplicated rows in the Register table.

What is the reason of having them duplicated?

i.e. What is the granularity of the Register table?

-- How the Register table relates to the Turnup one?

Are there fields that common in both? Or may be

they could be built using some calculations?

These are questions helping to make sense of data.

Others may follow, but after answering those first.

Yours,

Yuri