3 Replies Latest reply on Apr 30, 2018 3:47 PM by Yuriy Fal

    Window_Corr doesn't yield correct value

    Sheng Zhong

      Hi, Tableau fans

      Thanks for your help. I selected supplier dimension, the output value is not right either. I attached a twbx with this message. The exact issue was, for each supplier, it seems window_corr doesn't yield correct values. For example, the following data, the 1st row is rate, 2nd row is volume. 3rd row is correlation coefficient(-0.0183). However, when I check it on excel, it yields -0.0216. Where is my calculated field wrong?

       

       

      -0.0216

       

      This the formula for the calculated field "(N/A)Correlation Value"