1 Reply Latest reply on Jan 26, 2019 7:23 AM by Ken Flerlage

    ATAN2() function in Custom Query

    Snehal Kakade
      I want to calculate ATAN2(X,Y) in Tableau Custom Query where I have connected CSV using legacy connection. However I get error "Undefined function 'ATAN2'". Please help
        • 1. Re: ATAN2() function in Custom Query
          Ken Flerlage

          When you use the legacy connection, it appears to use the Microsoft Jet database engine (basically what MS Access uses). Despite ATAN2 being part of ANSI standard SQL, it does not appear that this is supported by the Jet engine. Furthermore, support for legacy connections to text files will be dropped starting in Tableau version 2019.1, so you may wish to reconsider use of this type of connection (see Legacy Connection Alternatives). Why don't you just connect to the file, then perform the ATAN2 function using a Tableau calculated field?

          1 of 1 people found this helpful