Custom tables can be especially useful for flattening two tables.
Start by navigating to your database schema, and click Add custom table at the top of the schema page.
Name your table, and add your SQL. In our example, we’re joining three tables to get a rollup of User information. Click Add table when finished.
Chartio will evaluate your SQL and will display any error messages in the schema viewer.