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

    Correlation between 2 sources

    kris goh

      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