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?

      Month of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of DateMonth of Date
      (N/A)Correlation ValueJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18
      -0.018322499Avg. Base Rate114116127126127135136136139150153175185203234
      -0.018322499Trade Vol USD977,68710,650,73914,069,4211,593,13922,282,4274,872,31920,897,6897,912,07112,213,686901,2059,645,2418,240,2029,616,4436,983,80011,088,3220
      Excel Correlation Coefficient-0.0216

       

      -0.0216

       

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