InfoNet Dashboards

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.

Asset Groups and Files

Asset Groups and Files

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:

SQL 1 - Total Number Of Customer Complaints

SQL 1 – Total Number Of Customer Complaints

SQL 2 - Complaints By Year

SQL 2 – Complaints By Year

SQL 3 - Complaints By Contact District

SQL 3 – Complaints By Contact District

SQL 4 - Complaints By Effect

SQL 4 – Complaints By Effect

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.

Dashboard - Design View

Dashboard – Design View

Now we’ll add the widgets.

Adding a Widget

Adding a Widget

Once the widget is added we can specify the SQL it is to use as well as the dataset, that is the network.

Add SQL & Network

Add SQL & Network

Now customise what it will look like and then add and customise the rest of the widgets.

Total Complaints Customisation

Total Complaints Customisation

Complaints By Year Customisation

Complaints By Year Customisation

Complaints By Contact District Customisation

Complaints By Contact District Customisation

Complaints By Effect Customisation

Complaints By Effect Customisation

Finally hit the ‘Update and View’ button to generate the actual Dashboard.

Dashboard

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.

Back to the Designer

Back to the Designer

Share this post!

    About Idris Nujjoo

    Idris is the Product Sector Leader for InfoNet and InfoMaster and has been working for Innovyze (and its earlier incarnations) since 2001 and specifically working on InfoNet and Asset Management for the past decade.
    This entry was posted in InfoNet. Bookmark the permalink.