Advanced

Foreign Keys

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.

Learn more about Foreign Keys

Dashboard Variables

Dashboard variables allow you to dynamically filter multiple charts at a time using a dashboard widget such as a dropdown or a text input.

Learn more about Dashboard Variables

Drilldowns

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.

Learn more about Drilldowns