EasyVista KPI Data Source

Last modified on 2022/08/17 17:50

Apps - Datasource - EasyVista KPI icon.png This data source belongs to the Applications category in the data source library. It is used to define a dynamic data source linked to a trend defined in Service Manager.

Notes

   Open url.png See General remarks on data sources.

  • An EasyVista KPI data source is always associated with an EasyVista IT Service Manager connector.
  • It can point to all trends defined in Service Manager (Administration > Trends > Trends) (subject to access rights).
  • Logged-in users can only access to:
    • Service Manager menu options authorized by their profile (list of parent queries). Open url.png See the default app profiles and domains.
    • Filters and views defined for the selected parent query authorized by their profile.

Best Practice

  • When data in the data source is refreshed, the trend will not be recalculated. When you define the refresh frequency in the Auto Refresh property, you should specify a value greater than the frequency for calculating the trend. This way, the new calculated trend value will be displayed.

Example

View the number of incidents created this week using the trend created in Service Manager

  • Data source linked to the Number of incidents created this week trend (trend calculated twice a day)
  • Display data from the data source using a KPI widget
Service Manager data Display using a KPI widget
Apps - datasource EasyVista KPI - Example Datasource.png Apps - datasource EasyVista KPI - Example Chart.png

List of properties

Content

AliasConnector

Alias/Connector: easyvista IT Service Manager connector used by the data source to access Service Manager.

Query: Trend defined in Service Manager.

ApplyDomains

Apply Domains: Used to indicate if the trend is calculated for the user's current domain (box is checked) or for the Whole Company domain (box is not checked). The user's current domain is the one selected in the user information zone in Service Manager.

Preview

Configure Field Types: Used to open the field editor that enables you to select data source fields and specify the type of each field, e.g. date, integer, etc. when this is not automatically detected.

  • The Apps - datasources Properties - Preview button.png button below the property shows the number of rows (max. 15) and columns extracted. Click to open the editor.
  • The button will display No data available as long as you have not selected any of the mandatory elements for the data source.
  • In edit mode, only the first 15 data source records are displayed.
  • In execute mode, all of the data source records are displayed.
  • Data in static data sources comes from the last file upload.
  • Data in dynamic data sources is refreshed when you open the app in edit mode.
SelectFirstRowAsCurrentRecord

Select First Row As Current Record: Used to indicate if the first record of the data source, when displayed in widgets, is selected by default (box is checked) or not (box is not checked).

NoDataMessage

No Data Message: This message is displayed when the data source does not contain any data.

  • Enter the code directly in the field or click Apps - Edit Html icon.png to open the text editor
AutoRefresh

Auto Refresh (Note: Only for dynamic data sources): Used to indicate the automatic refreshment interval for data from the data source in hours/minutes.

  • Data is automatically refreshed each time the app is run and each time the page is redisplayed, regardless of whether it is in execute mode or edit mode.
  • Caution: The updating of data requires additional activity on the Service Apps platform.

     Best Practice icon.png

  • You should define an automatic refreshment interval only if the app is required to constantly display real-time data for long periods of time on screen.

    example  View dashboard data

  •  You should not specify an automatic refreshment interval if the app is only used for displaying a snapshot of data.

    example  Display a portal where catalogs can be consulted

Tags:
Powered by XWiki © EasyVista 2022