If you’d like to make a chart with data from multiple tables in a database, you’ll need foreign keys in your schema. Foreign keys tell Chartio how to combine multiple tables together in one query (dataset). When building your query, you’ll know if foreign keys are not set up when a table you want to use is disabled in Interactive Mode.
Dashboard variables allow you to dynamically filter multiple charts at a time using a dashboard widget such as a dropdown or a text input.
Chartio’s Drilldown functionality allows you to click an area on a chart to update a Dashboard Variable value. The Dashboard Variable then updates any charts that are connected to it.