Linking Dashboard Components
You can build surprisingly complex charts by following these simple steps.
You can add queries that include query variables to dashboards to create dynamic dashboards with charts and tables that change based on a text or date input.
First, create a query that uses a query variable. For information on how to do this, refer to the document on query variables here. Add this to a Dashboard by clicking on the 3 dots in the top right of the Results Pane and choosing Add to Dashboard.
Adding a query to a dahsboard.
Second, once the query is added to a dashboard as a chart or table, right-click on its title and choose Configure Chart.
Configure a chart or table to link it to a Dashboard input using a query variable.
In the right-hand context menu, you will see inputs to the query that are titled after the query variables you used. In the image above, {{end_date}} and {{start_date}} are both query variables that are shown in this menu. Next to these inputs, click the gray link button. If an input such as a text input or a date picker has already been linked to this query variable, the link will be pink instead of gray.
Click the link button in a chart or table that uses a query that contains query variables. Then, select which input in the dashboard you want to link the query to.
Finally, you will see a menu to choose which dashboard input, such as a text input or date picker. In the example above we have a date picker input named endDate that has already been added to the dashboard. We select its value property to link the user-selected date to the end_date query variable. Select your input and the value you would like to use from it.
This feature also applies to tables and rows which means you can build charts that change based on clicking a row in a table. For more examples of the surprisingly complex charts that can be built, see this blog post on visualizing sales data in a dashboard.
Copy link