0 Replies Latest reply: Sep 13, 2017 10:41 AM by Andres Prato RSS

    I am doing a Direct Query, but get error in chart when analyzing data

    Andres Prato

      When I try to put my data in a table, this error comes up. I don't understand since I created the same report without Direct Query and works fine. I am trying to use the Direct Queries to see how they work



      Screen Shot 2017-09-13 at 10.40.18 AM.png

      The query goes like:

           DIRECT QUERY



                     other fields

               from tableA, tableB, tableC, factTable

               where tableA.id = factTable.id

                and tableB.clientId = factTable.clientId

                and tableC.otherId = factTable.otherId


      Thank you,