Dashboards allows users to display their data graphically, thus drawing out and displaying it as useful information. Dashboards in InfoNet display simple graphics (called ‘widgets’) like a numerical, a pie chart, graph or simple table. Note that it is SQLs that are used in Dashboards to supply the widgets with the data.
As an example for this blog, I’m going to outline how to create an example dashboard, built around Customer Complaints and some Customer Complaint statistics that I think may be of interest. Note that a dashboard can display widgets about any InfoNet object or set of objects on the one dashboard. I am simply choosing, keeping things simple, to build a dashboard with widgets built around just Customer Complaints.
First of all I’ll create the filing structure i.e., Asset Groups in which to create my dashboard and the required SQLs.
The SQLs that I’m creating need to generate a table output, be it a single numerical output (a table consisting of a single cell) or a table of one or two columns. It is beyond the scope of this blog to explain how these SQLs work (you can read all about generating tables using SQL ‘SELECT’ statements in my other blog posts or in the InfoNet HELP).
The SQLs are as follows:
Now we have the SQLs finely tuned to produce the stats that we are after displaying, we can add these to the Dashboard. This is done by accessing the design view of the dashboard, by simply opening the file.
Now we’ll add the widgets.
Once the widget is added we can specify the SQL it is to use as well as the dataset, that is the network.
Now customise what it will look like and then add and customise the rest of the widgets.
Finally hit the ‘Update and View’ button to generate the actual Dashboard.
A final tip, right clicking on the Dashboard allow its update or a return to the designer. A save to HTML is also available, which can be used to create files which can be published on a webserver.