Dashboard/LCA query History check box

Solved252 viewsdashboards app LCA
5
0 Comments

When in a Dashboard/LCA a new query based on get parameter table by ID an History check box appears
Was not able to documentation regarding this option, what is the information retrieved when this option is selected?

Example:

Joaquim Almeida [SLC] [DevOps Enabler] Selected answer as best 12th March 2025

1 Answer

6
19.21K 1 Comment

Hi Joaquim,

When history box is checked, the GQI query will show the historical data (trend data) related to the selected column parameter.

If average trending was enabled on the selected parameter, the following columns will be available:

  • Instance (DK)
  • Instance (PK)
  • Start time: Start time of the record
  • Stop time: End time of the record
  • Min value: Min value in the time slot (5 min)
  • Average value: The average value calculated over the time slot
  • Max value: Max value in the time slot (5 min)

If real-time trending was enabled on the selected parameter, the following columns will be available:

  • Instance (DK)
  • Instance (PK)
  • Star time
  • End time
  • Value

Hope it helps.

Joaquim Almeida [SLC] [DevOps Enabler] Selected answer as best 12th March 2025
Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented

Do note that this is only available when having the GenericInterface soft launch option, so this should not be used in production. This data source is not available in the GQI DxM, as an alternative there is the 'Get trend' or 'Get ad hoc' data sources.