How do I trigger a Query to refresh a chart in a Dashboard, when I change the value of a prompt?
11/10/2018

A chart or graph will be linked to cells in a spreadsheet tab which will, in turn, be linked to the output of a query.

What we need to do is ensure that a trigger cell is added to the particular query you want to be refreshed.
To do this edit the query and progress to the last stage and set the trigger cell for the radio button when cell value changes.

We will then need to ensure that when clicking on an element of the dashboard or the chart an insertion method is configured to insert some data into a cell.

This cell will be then connected to a prompt in the query and as this will be the trigger cell as the value has changed the query would be retriggered.

This will then refresh the data in the query and subsequently refresh the chart or graph.

By using keyintelligence.uk, you agree to our use of cookies to enhance your experience.