How to Build Multi Chart/Table Reports in Entuity Network Analytics (ENA)
This article is going to show you the basic concepts of Multi Chart/Table Reports and how to build them in Entuity Network Analytics to have better control of your network management while navigating around your network.
- Multi Chart/Table
- Report Builder
- Entuity Network Analytics
- Network Management
To build a Time Series Chart, the appropriate template should be selected from the Report Builder, which is available from the Main Menu→ Reports Page. As we have mentioned in previous blog posts, there are four different fundamental templates. In this case, you should select the third one, the Multi chart/table.
As an example of this type of report, I am going to create a report that will display charts containing the in-and-outbound utilization for the collection of ports. An Attributes Dashboard will be needed to drag my selected attribute from. Similar to building a time series chart report, I am going to duplicate the existing browser tab, select the Dashboards, select a Port by using the Explorer and then select the Attributes Dashboard from the All Dashboards Menu.
Let’s sort this in alphabetical order.
I am going to drag the Inbound Utilization metric into the first attribute entry in the Report Builder. Here is the Inbound Utilization attribute and I will drag it up to the Report Builder tab and wait for the contents to change and then drag it down to the first attribute. Try to drag again for the Outbound Utilization metric. Alternatively, you could also try to drag attributes by using two browser windows.
If you wanted to restrict the report to either a specific component or a small fixed collection of components, then attributes from those components could be dragged into this section of Report Builder to define that collection. Alternatively, a View can be used to define which components will be included. If you have not made use of the selection facility as is the case here, you’ll need to ensure that the correct Object Type is selected before you can use the View selection. This defaults to Devices, and in my case, should change to Ports. I’m going to select the View mode and choose a View.
Clicking the Preview button brings up a preview window containing a sample of the report. Although the chart contents look appropriate, there’s currently no way to identify which ports they are applied to. The optional Tabular Section of the report is one way to address that.
I’m going to drag the Interface Description and the Device Name as two of the tabular attributes. But the table is empty by default, so they must be created first. You’ll need to hit the Add Column button twice and drag Interface Description and Device Name into those tabular attributes. (See how to add attributes above for details.)
Looking at the preview of the report confirms that each chart is now appropriately identified and you can recognize which ports they applied to.
There’s another way in which the tabular attributes can be used and that’s to show a summarization of one or more of the time series metrics. Let’s add a display of the Mean or Average for both of the charted metrics. I will need two more entries for the tabular data table now. Use Inbound Utilization and place that in the third of these tabular attributes. Here’s the Outbound Utilization which goes to the last one.
Now I will click the links in the Value column. This allows the aggregation method to be defined rather than just taking the last value in the reporting period. I’m going to choose the Mean which is going to average the data over all of the samples in that reporting period. And do that again for the Outbound Utilization.
Previewing the results shows the value of this style of presentation.
You’ll notice that the number of components included in the report can be restricted by defining the maximum number of rows. And our sorting options available in the tabular section to control the order in which the components are presented.
A chart title can be added which is displayed using a larger bold typeface and attributes can be incorporated into that title if needed. There are also several additional ways in which the report can be refined with many of the more advanced options displayed when the show Advanced Options box is checked. There are now more options to control the layout of the table apply additional markup to the output text, so that font sizes can be changed bold and italic text can be displayed and other such embellishments.
There’s also an option to allow rules to be added to pick and choose which components to be included and which to be ignored. Once you’re satisfied with the configuration of the report, it can be given a name. I am going to name it “default” in this example and then publish to the user-defined reports folder. From here it can then be launched and rescheduled.
One point you should remember when you build a report and you’re considered to be its owner, which allows you to modify its configuration at a later date via this icon.