Best way for converting report to dashboard

Solved818 viewsDashboards
0
0 Comments

Hello,

I have the following report that I would like to migrate to the HTML5 dashboard app:

  1. List of all the elements with state
  2. List of the value of one (or more) parameters for all elements of a given protocol.

What is your advice on the best way to do this?

Thank you.

Best regards

Bruno Sousa

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023

2 Answers

2
10 0 Comments

Hi Bruno,

Both your examples are both great use cases of GQI queries:

  1. Get elements
  2. Get parameters for elements where

Note that additional operators on these data sets can be added to, for instance, filter or aggregate. There are also different visualizations for your data such as a chart, table or node-edge.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023
2
15.99K 2 Comments

Hi Bruno,

For the first use case, you could use GQI to retrieve the list of elements available in a DMS. When creating the query, select as data source 'Get elements':

Below an example:

For the second use case you could use GQI as well, but this time select as data source 'Get parameter for elements where' (option 'Protocol'). Below an example of the result of the query:

Euler Peron [DevOps Member] Posted new comment 4th May 2022
Bruno Sousa [DevOps Advocate] commented

Thank you both for the suggestions!

Best regards
Bruno Sousa
Euler Peron [DevOps Member] commented

Miguel and Bruno, how would it be done in the gqi to get some trending statistics for historical data of those analog parameters? Like Avg, Max, Min and so on for a given period?

It would be very aprecciated to have such addition to the report