The Data Transformer


The Data Transformer enables you to act perform actions on a data source in order to:

  • Define its structure by indicating the Dimension column (by default, the first one in the data source) and the Measure columns (by default, the following ones). Open url.png See Standard data source structure.
  • Define its scope. By default, the widget pointing to the data source takes into account all of its measures but you can exclude certain columns if you do not want to process their values.
  • Convert data by applying statistical aggregate functions, such as the minimum or average, to all values in a measure.
  • Modify the display order of the Measure columns in Dashboard widgets. By default, measures are displayed in the order of the columns in the data source.

Example

You want to display a chart for incidents per employee for three departments, Sales, Marketing, and Administration

Data source Bar Chart widget

Note:

  • The Dimension column is the first one in the data source, Department.
  • Only the Measure column, Incidents by Employee is selected.

    EVApps - widget Bar Chart - Example DataSource.png

    Download Zip icon.png Download example (CSV file)

EVApps - widget Bar Chart - Example Chart.png

Notes

  • If you need to apply statistical aggregate functions to data in an MS SQL Server data source, we recommend that you use an SQL query.

Caution

  • You must ensure that the Dimension column is the first column in the widget.

Screen description

The Data Transformer is made up of two zones:

  • The left pane is used to:
    • (1) Select measures and statistical aggregate functions.
    • (2) Modify the display order of fields in the widget by clicking Apps - Move down arrow icon.png and Apps - Move up arrow icon.png, or remove a displayed field by clicking Apps - Delete 2 icon.png.
  • The right pane (3) is used to preview the contents of the widget's fields.

       EVApps - widgets Properties - Data Transformer.png

Access: In the Properties Inspector of a widget, click [ SETUP / PREVIEW DATA ] found below the Data Transformer property

Note: Once you modify the scope of the data source, the button name will display the number of selected columns.

Example documentation icon EN.png  [ SHOWING 7 COLUMNS ]: Means that seven columns were selected from the data source.

 

Choose columns to display: List of fields (measures) available in the data source.

  • The list of fields visible in the widget is displayed at the bottom of the left pane (2). By default, all are displayed.
  • To display a new field in the widget, select it from the list and click Apps - Add icon.png. The measure will automatically be added to the list (2) and appear in the Preview pane (3).
  • To remove a displayed field, click Apps - Delete 2 icon.png next to the relevant field in the left pane (2).

Optional aggregate function: List of statistical aggregate functions available.

  • To apply a function to one of the data source measures, select it from the Choose columns to display list. Apply the function you want. Next, click Apps - Add icon.png. A new column will automatically be added to the list (2) and appear in the Preview pane (3).
  • Description of functions:
    • maximum: Returns the maximum value of the selected measure.
    • minimum: Returns the minimum value of the selected measure.
    • average: Returns the average value of the selected measure.
    • sum: Returns the sum of values.
    • count: Returns the number of values.
    • date: Only for DateTime fields, returns the date.
    • time: Only for DateTime fields, returns the time.

      Note: The date and time displayed depend on the configuration defined in the information zone of the logged-in user. The date and time may also depend on the configuration settings of the platform used by the logged-in user. In Windows, this is specified in the Control Panel > Regional and Language Options.

         Example documentation icon EN.png  

  • count(Problem Number) ==> Displays the total number of problems
  • Creation Date = 20170906T11:15:56+000
    • date(Creation Date) = 06/09/2017
    • time(Creation Date) = 11:15:56

Preview: Preview of the field contents displayed in the widget.

  • Click and drag the column headers to arrange fields in the order you want. You can also use the Apps - Move down arrow icon.png and Apps - Move up arrow icon.png arrows in the left pane (2).

Procedure: How to use the Data Transformer

1. In the Properties Inspector of the widget, click the button found below the Data Transformer property.

2. Select the measures that belong to the scope of the data source.

  • Select each column you want from the Choose columns to display list. Caution: Ensure that the first column is the Dimension column.
  • If required, select the aggregate function you want to apply to the values of this column from the Optional aggregate function list. 
  • Click Apps - Add icon.png.
  • Click Apps - Delete 2 icon.png next to a column in the list (2) if you want to delete it.

3. Click and drag the column headers to arrange columns in the order you want in the Preview table. You can also use the Apps - Move up arrow icon.png Apps - Move down arrow icon.png arrows next to each of them in the list (2).

4. Click [ OK ]. The button found below the Data Transformer property in the widget will display the number of columns selected. The modifications will be applied to the widget and the Design pane in the graphic editor will automatically be updated.

5. To return to the initial scope of the data source, click the button found below the Data Transformer property in the widget and click [ REMOVE ]. The button name will switch back to [ SETUP / PREVIEW DATA ].

Tags:
Last modified by Unknown User on 2017/10/10 13:59
Created by Administrator XWiki on 2014/09/02 12:17

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018