Share Query Results with another Panel

FojiSoft let you use the query result from one panel for any other panel in the dashboard.Sharing query results across panels reduces the number of queries made to your data source, which can improve the performance of your dashboard.

The Dashboard data source lets you select a panel in your dashboard that contains the queries‌you want to share the results for. Instead of sending a separate query foreach panel, FojiSoft sends one query and other panels use the query results to construct visualizations.

This strategy can drastically reduce the number of queries being made when you for example have several panels visualizing the same data.

Create a dashboard.
Change the title to “Source panel”. You’ll use this panel as a source for the other panels.
Define the query or queries that you want share.
Add a second panel and select the Dashboard datasource in the query editor.
In the Use results from panel list, select the first panel you created.

All queries defined in the source panel are now available to the new panel. Queries made in the source panel can be shared with multiple panels.

You can click on any of the queries to go to the panel where they are defined.