How to Create Table for Forward Power for 30days

Solved670 views
2
2 Comments

Hi Dojo,

We've come across to create a table for Forward Power one site for 30 days.

Kindly guide how to create the table as per below on Dataminers Dashboard:

Appreciate for you assistance.

Thank You.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 4th July 2023
Michiel Vanthuyne [SLC] [DevOps Enabler] commented

Hi Muhamad,

The approach to show it in a dashboard would depend on the source of this data. Is this data already stored by e.g. an element on your DMS?
Muhamad Nor Iman Hasan commented

Hi Michiel,

Yes the data is store on DMS. We have also enabled trending for this parameter. Could you help us out to achieve this table?

2 Answers

1
813 2 Comments

Hello Muhamad

I did some investigation and currently what you need to achieve is possible only via a Plot of the Trend Data, you can create a plot by using a Line & Area Chart Object and then assigning the Parameters and elements

You can define 30 Day Span

And select the Parameter in the Data

And the elements in the Filter

But for the Average and to be able to generate data on a query for a table as you requested, that is part of a new Dataminer Feature for the GQI that it will only be available on the Main release in 10.4.0 and on the feature Release in 10.3.2

It will look something like this

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 4th July 2023
Ashwiny J K Anandan [DevOps Advocate] commented

Hi Tiago, appreciate your reply.

We are currently running on 10.2 CU10, therefore unable to execute the suggested steps.

Based on the table shared, we noticed that the average value is available on a few time range in a day. How can we configure the table to only display the overall average value per day?
Tiago Pinhao [SLC] [DevOps Enabler] commented

Hello Ashwiny

In the example above i only had a few valuesbecause it is a testing server, but in your Trending Data you should a continous line, not sure I understood your question, on the View above you can define the Range by default oif what you would like to see
0
15.99K 1 Comment

Hi Muhamad,

In order to help you, we will need additional information from your side:

  • Is this information coming from an element, and if so, please could you let us know the connector?
  • What value you plan to display in the table for each day? The max value in that day, the average value from that day?

Based on this, we can see the options available in Dashboards - GQI that can help you achieve this requirement.

Kind regards,

Nur Aliah Nasution Mohd Asri Posted new comment 13th June 2023
Nur Aliah Nasution Mohd Asri commented

Hi Miguel,

The data/ information is coming from elements in DMS.

The connectors used are :

1.Rohde Schwarz THU9 – Transmitter, Version Production: 1.1.0.11 for Forward power value
2.Enensys EdgeProbe Advance, Version Production 1.0.2.10 for MER value

I want to display forward power and MER average value per day for a month.

Appreciate your assistance to show us the steps to do in Dashboard-GQI to achieve this requested table.

Thank you.