Hi Martin,

I assume you have a single table where each row represents an “Interface” and has the following columns:

• Index (the primary key)
• Bandwidth (trended)

Then it should be possible with a GQI query to create a trend for the sum of the Bandwidth from multiple “Interfaces” in this table.

How to build the GQI query

This approach will require a hidden option for joining queries, named “Row by row”. To make this option available, add the showAdvancedSettings=true query parameter in the URL and refresh the webpage. See also: DataMiner Docs: Join

First, create a subquery to fetch the trend data:

1. Data source: Get trend data
   1. Select real-time or average trend data
   2. Select the protocol and protocol version for the element containing your table
   3. Select your table parameter
   4. Select the “Bandwidth” table column
2. Select columns: Start time, Index and Bandwidth
3. Filter on a specific element
   1. Filter method: regex
   2. Value: “^dmaId/elementId$” with the IDs for the element containing your table
4. Filter the Start time column on your dynamic time feed

This first query should not be executed on its own. We’ll now create a second query to select the specific interfaces, join on the trend data and then sum the trend values per trend interval:

1. Data source: Get parameter table by ID
   1. Select the DMA ID and Element ID for the element containing your table
   2. Select your “Interfaces” table
2. Select the Index column
3. Filter on the “Interfaces” as desired, e.g. using a regex.
   Each “Interface” row that matches will be included in the final sum.
4. Join on the trend subquery we created before:
   1. Join using the Index column of both queries
   2. Check the “Row by row” checkbox
      This option will only be available if you enabled the “showAdvancedSettings” in the URL.
5. Aggregate the Bandwidth column
   1. Select column “Bandwidth”
   2. Aggregation method: “Sum”
   3. Group by “Start time”

The result will be a table with columns “Start time” and “SUM(Bandwidth)” where each row represent an individual trend point. This can then be visualized in a line chart as a single line.

Example query with a different table

Hi Martin,

A possible option to perform this aggregation is using GQI queries. Using the data source Get parameters for elements where you can retrieve values from column parameters. Using the filter operator, you can filter values from specific interfaces.

Below an example. In this case we are filtering two interfaces: ‘Ethernet1/1’ and ‘Ethernet1/2’:

Using the ‘Aggregate’ operator together with option ‘Group by’ you can sum the values for each table and group by element:

If you would like to store this aggregation so it can be displayed in a trend chart, you could use Data Aggregator.

Hope it helps.