4 Replies Latest reply on Apr 21, 2012 7:35 PM by Elizabeth Coleman

    how to calculate median between two dates?

    Elizabeth Coleman

      Hello,

       

      I need help in calculating the median between dates.  For instance if I want to know the median of when the orders were created and when they invoiced.  I've attached a sample Tableau file for analysis.  Here is a sample of my data: 

       

      Order                    Created            Invoiced

      6300000012           12/1/2011         3/31/2012

      6300000013            1/1/2011          3/2/2012

      6301000015             2/1/2011          6/25/2011

      6301000017             6/1/2011          8/12/2011

      6300089099             4/1/2011          11/3/2012

       

      Thanks for your help.