4 Replies Latest reply on Jan 11, 2018 5:37 AM by Manuel Pérez Tórtola

    How to add Pearson Correlation coefficient at sub-total row

    Manuel Pérez Tórtola

      Tableau Desktop 10.3

       

      Hi all,

       

      I'm quite  new at Tableau and I'm stuck with this issue. I’ve been dealing with it for several days and I can’t find the solution.

       

      I’m working with Pearson Correlation Function (WINDOW_CORR)

       

      Just for the for this example based on Superstore data source I’m working with quantity and sales to find the Pearson correlation based on Order ID.

       

      What I want to do is:

       

      • To show Pearson CI at subtotal cell (In the case of sub-Category Accessories, 0,4247)
      • To show SUM(Sales)*Pearson CI. (Accessories $167,380 * 0.4247 = $71,086)

       

       

      I’ve been dealing with the solutions shown on these great posts.

       

      http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-1/

      http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/

       

      Unfortunately, I haven’t been able to solve the issue.

       

      Could anybody tell me what should I do? Or, even better, could anybody work  directly in the file I attach?

       

      Thank you very much in advance.

       

      Manuel

      Valencia - Spain

       

      Message was edited by: Manuel Pérez Tórtola