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!