How to obtain average MER trend graph?

Solved1.18K viewsDashboard
0
0 Comments

Hello

I need to have a trend graph showing the average MER parameter calculated from an "n" number of channels across various Trilithic elements (please note that this parameter is a column in a table for each Trilithic element)

What is the best way to achieve this?

Thank you.

Best regards

Bruno Sousa

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th August 2023

1 Answer

0
16.33K 4 Comments

Hi Bruno,

I believe GQI should be an option in this case. You could build your GQI query as follows:

  • Data Source: Get parameter for elements where
    • Protocol: The protocol used by the Trilithic elements
    • Version: The version used by these elements (most probably production)
    • Parameter: The table where the information is located
    • Select: The index and the column of the table that contains the MER value
    • Aggregate: Select the column that contains the MER value
      • Method: In this use case, will be average

This query will provide you the average value from all the MER values available in the query result. Please keep in mind that you can perform extra operations, for example 'Group By' .

More information in DataMiner Docs (Aggregate operator)

Hope it helps.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th August 2023
Bruno Sousa [DevOps Advocate] commented

Hi Miguel!

Thank you for the reply!

2 doubts:
1. How can I put the name of the device? In the query I only see the ElementId to choose from..

2. When I try to put the results of the query in a “trend graph” it shows an error saying that there are no dimensions configured: how can I configure those?

Thank you.

Best regards
Bruno Sousa
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi Bruno,
1. In this case you will need to add an ‘Ínner Join’ with the data source ‘Get Elements’. The link between you previous data source ‘Get parameter for element where’ and ‘Get element’ is the element ID. After performing an inner join, you can add the column ‘Name’ from the other ‘Get Elements’ data source.
2. Once you select the trend line component, go to ‘Settings’. You will see the option ‘Dimensions’. Select the query that you would like to use as source to display the trend chart. There will be two additional options: ‘X Axis’ and ‘Y Axis’. Select the columns for the X and Y axis. The X axis should be linked to the column that contain the timestamps.
Hope it helps.
Bruno Sousa [DevOps Advocate] commented

Hi Miguel.

Thank you for the feedback!

Regarding the point 2., I don’t seem to have “timestamp” information ( I used the query you sent for the average (MER))

The query output shows the Trilithic elements and the average value of MER (how is this average value shown calculated since is an average?)

Am I missing something in the query since I don’t have timestamp information? I’m using the “Get paramaters for elements” data source as you advised.

Thank you.

BR
Bruno Sousa
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi Bruno,
Regarding point 2, there is a mistake in my answer. Since you are using the data source ‘Get parameter for elements where’, there is no column showing the timestamp. You will only get the timestamps if you get historic data (e.g. using the data source ‘Get trend data’).
With the current GQI that you created, you will get the current average value of the rows displayed in the result.