Aggregating trending data from different parameters

Solved139 views
0
0 Comments

Is there any option to aggregate trend data from different parameters and to show it in a line graph?

Stefan Tosic [DevOps Advocate] Selected answer as best 4th November 2024

1 Answer

2
15.99K 2 Comments

Hi Stefan,

Yes, there are couple of options:

  • Aggregation rules: You can define aggregation rules at view level. These rules allows you to perform basic aggregations.
  • Data Aggregator: This DxM allows you to schedule GQI queries that can perform complex aggregations. Results can be stored in a CSV file. You can use this information for the line graph.

Hope it helps.

Stefan Tosic [DevOps Advocate] Selected answer as best 4th November 2024
Stefan Tosic [DevOps Advocate] commented

Hi Miguel,
Thanks for the answer.
The idea was to sum a column with numerical trending data (Bitrate) from a table that is retrieved via SNMP connector for a Mikrotik Router. Is it better to create a derived parameter along with a QAction where it will sum all the cells in the column or to do it with an aggregation rule?
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi Stefan,
I believe your use case can be implemented using aggregation rules. However the main limitation will be that (by default) the aggregated value will be done at view level. If a view contains more than one element, the aggregation rule will sum the bit rate from all the elements in the view. However, you can apply grouping based on element property.
In case aggregation rules does not fit your use case then indeed you could implement the aggregation rule in the connector.
Hope it helps.