Is there a way to display trend data for multiple elements, grouping measurements by time and setting the X and Y axis as desired?
For our scenario, we have a rotator controller setup to an antenna which is collecting readings for the current angle of direction.
Then we have different elements making power and interference readings from the antenna which we would like to correlate to the antenna angle as the rotator is activated.
Today, we can show the trend lines for the readings from the Antenna Controller and measurement equipment, however, the X-Axis is always the timeline.
What we would like to do is set the X Axis to the angle, then have the associated readings (from the other element(s)) displayed as the value based on the associated timeline reference created a bar chart showing the reading levels based on antenna direction.
To complicate a little further, this is a single Windows server implementation (DataMiner and Cassandra on a single server), so there is no Elastic database available today. If there is a possible solution using DOM or LCA we can discuss adding an Elastic server.
At the moment I believe the solution is to create a custom table driver which records (time, angle, readings 1 - x) then we can use Visio or Dashboards as the data is already correlated. I am just checking to see if there is another way.
Final solution thanks to Ronalds's input...
User selects initial timeframe from time control buttons at top of page, then zooms in on desired full rotation from top trend line. This selection then gets applied (via GQI) to the bar and line charts below with the custom axis.
To build we used 3 GQI queries, probably not necessary, but kept the solution clean for initial deployment.
Query 1 Collected Trend Data from the Rotator Element:
Query 2 Started from above query, then joined in the RSRP reading element:
Query3 Was used so I could collect just the readings I was interested in from Query2 above to use on the Line and Bar Charts, allowing me to select the X and Y axis values.
The final step was selecting the Chart shape from the Dashboard and using the settings page to set the 'Dimension' to set the Axis data.
