xTuple Dashboards Product Guide

The KPI charts and visualizations consist of two pieces, a data query and a datasource. The data query is an SQL query to your xTuple database that returns the data the chart will display. A datasource defines what charts or visualizations to use with the data query, what size to display them at on the dashboard and which users are allowed to see it. The KPI datasource is then available to be added to any dashboard.

Each dashboard is a window that you can add panes to. Each pane loads a KPI datasource and displays its chart or visualization. Depending on how the datasource is defined, you can change the chart type to various different charts, such as bar, line, pie, gauge, step, etc. You can also define the size of each pane by changing its layout setting to make the chart big or small. When the Dashboard tab loads, it will load all of its panes, and then each pane will request the data from the datasource and render its chart or visualization. The data can be refreshed from the panes menu as needed to get updated data.