This content has been marked as final.
Show 4 replies

1. Re: how to calculate median between two dates?
Alex Kerin Apr 20, 2012 12:26 PM (in response to Elizabeth Coleman)Would the end result be the median number of days, or a median date (can't rationalize what this would look like)?
If the former then this:
(datediff('day',[Order Create],[Invoice Date]))
and dragged in as a median aggregate should work. You need to have an extract (at least for your current source) to be able to use median.

2. Re: how to calculate median between two dates?
Elizabeth Coleman Apr 21, 2012 1:59 PM (in response to Alex Kerin)Hi Alex,
Median is not one of the choices when I dragged the calculation to the Level of detail shelf.

3. Re: how to calculate median between two dates?
Alex Kerin Apr 21, 2012 4:21 PM (in response to Elizabeth Coleman)You need to create a tableau extract to use functions like median

4. Re: how to calculate median between two dates?
Elizabeth Coleman Apr 21, 2012 7:35 PM (in response to Alex Kerin)Thanks that worked.