2 Replies Latest reply on Oct 6, 2017 7:02 AM by Bartek Balos

    ROW_NUMBER Function not working Tableau SQL

    Shubhangi Agarwal

      Hi ,

       

      Following code is not working tableau , However it works fine in SQL.

       

      Code : select DISTINCT Application_ID,Time_Stamp_Start,cpu_avg,ROW_NUMBER() OVER(PARTITION BY Application_ID, Time_Stamp_Start ORDER BY cpu_avg DESC) Ranking FROM statistics

       

      Error :

      • Database error 0x80040E14: Syntax error (missing operator) in query expression 'ROW_NUMBER() OVER(PARTITION BY Application_ID,Time_Stamp_Start ORDER BY cpu_avg DESC) Ranking'.
      • ; The query: SELECT TOP 1 * FROM ( select DISTINCT Application_ID,Time_Stamp_Start,cpu_avg, ROW_NUMBER() OVER(PARTITION BY Application_ID,Time_Stamp_Start ORDER BY cpu_avg DESC) Ranking FROM statistics ) [TableauSQL]
      • Unable to connect to the Microsoft Access database "C:\Workfiles\EY INDIA\Unilever\CPU Memory Dashboard\ReportingAPI4.accdb". Check that the path is correct and that you have access privileges for the requested file.