2 Replies Latest reply on Jan 26, 2014 10:50 PM by Sukant Arora

    What is the unit of the distance calculated in tableau?

    Sukant Arora

      I want to mention the unit of distance field in tableau.

      I have used the following formula:

       

      3959 * ACOS

      (

      SIN(RADIANS(LOOKUP(AVG([LATS]), First()))) * SIN(RADIANS(AVG([LATS]))) +

      COS(RADIANS(LOOKUP(AVG([LATS]), First()))) * COS(RADIANS(AVG([LATS]))) * COS(RADIANS(AVG([LONGS])) - RADIANS(LOOKUP(AVG([LONGS]), First())))

      ))