2 Replies Latest reply on Jan 28, 2019 2:57 AM by Chris McClellan

    Cutomize the data with a help SQL quries?

    M D

      I have over 30 databases on MySQL server and I have picked 4 database of them to create a online live dashboard with Tableau.

      Via SQL software I have wrote a SQL queries for what I want in all tables but the problem is every time I have to export and renew the file so I wanna avoid it and instead paste the SQL quries in Tableau and Tableau can create same file with all actions that made in SQL queries like joins and counting average and etc..

       

      I have tried to do it by connect MySQL database one by one in tableau and it works but the function "New custom SQL" only work when you marked a specific database its not like the SQL software that can create a new file with all SQL statements and join all connected MySQL databases.

       

      Is that possible to do it with Tableau?