{"id":9553,"date":"2016-02-19T12:43:48","date_gmt":"2016-02-19T04:43:48","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=9553"},"modified":"2019-08-27T10:42:41","modified_gmt":"2019-08-27T02:42:41","slug":"data-selector-4-4-1","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/data-selector-4-4-1\/","title":{"rendered":"Data Selector (4.4.1)"},"content":{"rendered":"\n

Related: For Explorer versions 4.3.2 and earlier, read the help on Add Time Series Data<\/a> and Adding a Dataset<\/a>. For help on the latest version of the data selector, see Data Selector<\/a>.<\/p>\n

Overview<\/h2>\n

Many of the Explorer components are used for displaying data. For example, the data label, charts, the dataset table, target bars, meters.<\/p>\n

Component data needs to be defined during design time, in Explorer Studio.<\/p>\n

This article explains how to select and define data, using the data selector editor.<\/p>\n

Data Selector Features<\/h2>\n

To open the data selector, click the drop-down list on a component property that shows the text \"Click to configure data...\", for example the Value<\/strong> property on the properties panel of the Data Label<\/strong> component.<\/p>\n

\"\"

Click the Drop-Down List \"Click to configure data\"<\/p><\/div>\n

The data selector opens as a separate panel below the property. The contents of this panel may vary, according to the type of data to configure (the data category) and how that data is to be returned (as a list, a set, or as a single data point).<\/p>\n\n\n\n
\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n\n\n
1. Value<\/strong>:<\/p>\n

This is the component property which uses the configured data. The name varies between different component properties.<\/p>\n<\/td>\n<\/tr>\n

2. Data Category<\/strong>:<\/p>\n

Click to select one of the data categories.<\/p>\n<\/td>\n<\/tr>\n

3. Configure Data<\/strong>:<\/p>\n

Configure data for the selected data category.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

A Component's Data<\/h2>\n

Depending on the data component, data can be defined for more than one of the properties.<\/p>\n

For example, a Meter<\/strong> component has Value<\/em> data (the value measured on the meter) as well as a whole series of Measures<\/em>, a Minimum Value<\/em> and number of Ticks<\/em>.<\/p>\n

\"\"<\/a>

Some of the properties on a Meter component<\/p><\/div>\n

Another example is the Data Label<\/strong> component, which has Value<\/em> data (a numerical value that is displayed on the label in run-time), as well as Decimals<\/em>, for formatting the data.<\/p>\n

Related: Components in Explorer<\/a><\/p>\n

Data Categories<\/h2>\n

Depending on what a component is used for, there can be up to five separate Data Categories<\/em> to choose from, when you select your data.<\/p>\n

\"\"<\/p>\n\n\n\n\n\n\n\n
\n

\"\"<\/p>\n<\/td>\n

Dataset<\/strong><\/td>\nTabular data returned from a dataset datasource.<\/td>\nUsing Dataset Data<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
\n

\"\"<\/p>\n<\/td>\n

Ad hoc Calculation<\/strong><\/td>\nAn ad hoc calculation using tags and\/or attributes.<\/td>\nUsing Ad hoc Calculation Data<\/a><\/td>\n <\/td>\n<\/tr>\n
\n

\"\"<\/p>\n<\/td>\n

Attribute<\/strong><\/td>\nA piece of data describing a specific characteristic of an entity.<\/td>\nUsing Attribute Data<\/a><\/td>\n <\/td>\n<\/tr>\n
\n

\"\"<\/p>\n<\/td>\n

Tag<\/strong><\/td>\nA piece of data or a calculation. This can also be referenced by an attribute.<\/td>\nUsing Tag Data<\/a><\/td>\n <\/td>\n<\/tr>\n
\n

\"\"<\/p>\n<\/td>\n

Value<\/strong><\/td>\nA fixed or variable numerical value, defined in Studio.<\/td>\nUsing Value Data<\/a><\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Categories are unavailable for components that can't use them. For example, the Combo Box component only has the dataset Dataset<\/em> and Value<\/em> categories available:<\/p>\n

\"\"<\/a><\/p>\n

Setting a Variable<\/h2>\n

When configuring data for a component, you will find that most of the properties have a Variable<\/em> option.<\/p>\n

For example, when you configure a new data label to use an ad hoc calculation, all of the calculation properties variable<\/em> options, as shown below.<\/p>\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To use a variable, click the variable<\/em> \"\" button, then select a variable from the drop-down list or type in a variable name, ensuring the variable suits the property. For example, when you configure Sample Method<\/em> to use a variable, that variable should be configured to have legitimate sample methods (Last Known Value, Average, Linear Interpolate and Raw<\/em>).<\/p>\n

Note that only variables of the correct type are available in the drop-down list (for example, where the property expects text, only text variables are available).<\/p>\n

Example<\/h3>\n

The following example illustrates how you can select a List variable for an Option Links' Option Values<\/strong>, and Text variable for its Selected Option<\/strong>.<\/p>\n

Related: Using Variables in P2 Explorer<\/a><\/p>\n\n\n\n
\n\n\n\n\n\n
1. List variable added to Default Values<\/strong>: Variable Name: ListofQuarters; Comma separated text values: Q1, Q2, Q3, Q4.<\/td>\n<\/tr>\n
2. Text variable added to Default Values<\/strong>: Variable Name: selectedQuarter; text value: Q2.<\/td>\n<\/tr>\n
\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n\n\n\n\n\n
3. List variable assigned to Option Links<\/strong>: Variable ListofQuarters is selected for the Option Links 'Option Values<\/strong>.<\/td>\n<\/tr>\n
\"\"<\/a><\/td>\n<\/tr>\n
4. Text variable assigned to Option Links<\/strong>: Variable selectedQuarter is selected for the Option Links' Selected Option<\/strong>.<\/td>\n<\/tr>\n
\"\"<\/a><\/td>\n<\/tr>\n
5. The Option Links<\/strong>: Showing Option Values<\/strong> (ListofQuarters) in the Option Links buttons, with Selected Option<\/strong> (selectedQuarter) underlined.<\/td>\n<\/tr>\n
\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Page Defaults<\/h2>\n

When you assign data to a component's property, you will find that very often the page default has already been assigned.<\/p>\n

For example, when you configure a new data label to use an ad hoc calculation, some of the calculation properties come with page defaults, as shown below:<\/p>\n\n\n\n
\n\n
\"\"<\/a>

The page defaults are added to the Default Values for a new Studio page<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You can view or update the page defaults on the Default Values<\/a> panel.<\/p>\n

 <\/p>\n

\n

Selecting and Configuring your Data<\/h2>\n

Explorer\u2019s Data Selector is used to collect data for properties of components, such as the Value<\/em> of a Data Label, or the Data<\/em> used by a Chart.<\/p>\n

Watch the video below to see how the different data is selected for a Data Label<\/em> component. Note<\/strong> that only the currently selected data category is saved when the page is saved.<\/p>\n\r\n\t\r\n\t

The video below shows how data is selected for a table.<\/p>\n\r\n\t\r\n\t

 <\/p>\n

\n

Using Dataset Data<\/h3>\n

Below is an example of the dataset configuration for a data label's Value<\/em> property which requires a single<\/em> numerical value.<\/p>\n\n\n\n
\n\n\n\n
\n\n\n\n\n\n\n\n\n\n
1. Component Property<\/strong>:<\/p>\n

This is the property that uses the data. In the example used, it is the Value<\/em>, used for a Data Label.<\/p>\n<\/td>\n<\/tr>\n

2. Data Categories<\/strong>:<\/p>\n

The selected category is highlighted, with details shown in the panel below the categories tab.<\/p>\n<\/td>\n<\/tr>\n

3. Dataset Query<\/strong>:<\/p>\n

The dataset query used to source a list of data for this component\u2019s property.<\/p>\n<\/td>\n<\/tr>\n

4. Filter Column, Filter Value<\/strong> and Value Column<\/strong>:<\/p>\n

Property components that require a single list of data (such as the Data Label's Value<\/em> property) use these three columns collectively, to specify a single point of data from the result set. Not all property components require this sort of filtering.<\/p>\n

Variation:<\/strong> Property components that require a single point of data (such as the Option Links's Option Values<\/em> property) only use the Value Column<\/strong><\/p>\n

Variation:<\/strong> Property components that require the full set of data (such as the Chart's Data<\/em> property) do not use these three columns.<\/p>\n<\/td>\n<\/tr>\n

5. Dataset Parameters<\/strong>:<\/p>\n

Not all queries have dataset parameters, and if they do these will vary depending on the query. These values need to be filled in before you can preview data.<\/p>\n<\/td>\n<\/tr>\n

\n

Note<\/strong>: Click Preview<\/strong> to see what columns and values are returned by the query. This is helpful for setting up filtering.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to Select Dataset Data<\/h4>\n

This example uses a Data Label. Some of the components' properties (such as the Chart's Data<\/em>) require fewer or no filter details.<\/p>\n

Step 1. <\/strong>Click the drop-down list next to the Value property to open the Data Selector.<\/p>\n

\"\"<\/a><\/p>\n

The Data Selector<\/em> editor opens, for the Value<\/em> property.<\/p>\n

Step 2. <\/strong>Click the Dataset<\/strong> category.<\/p>\n

\"\"<\/a><\/p>\n

Step 3. <\/strong>Select and configure the dataset.<\/p>\n

\"\"<\/a><\/p>\n

Step 3 a)<\/strong> Select a Dataset Query (or set a variable<\/a>).<\/p>\n

In this example, we select the AccountingProdAmts<\/em> dataset from the Explorer Training Data<\/em> datasource.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
\u00a0<\/td>\nBrowse for a Dataset Query<\/strong><\/td>\nOr<\/em><\/td>\nType in a Dataset Query Name<\/strong><\/td>\n<\/tr>\n
 <\/td>\nTo browse for a dataset query, click the ellipsis button next to the Dataset Query<\/em> edit box.<\/td>\n <\/td>\nAlternatively, type part of the dataset query name into the Dataset Query<\/em> edit box, and select a dataset query from the list filtered list.<\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n\"\"<\/a><\/td>\n <\/td>\n\"\"<\/a><\/td>\n<\/tr>\n
 <\/td>\nThe Choose Data<\/strong> window opens, with a list of every dataset query available to this installation of Explorer. Use the search options to locate the one you want. If a dataset has a description, this is listed below the name.<\/td>\n <\/td>\nThe selected name appears in the Dataset Query<\/em> edit box.<\/td>\n<\/tr>\n
 <\/td>\n\"\"<\/a><\/td>\n <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n1. Click on one of the available datasources (listed on the left panel) to filter the available datasets (Explorer Training Data, in this example).<\/td>\n <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n2. Type part of the dataset query name in the Search<\/strong> box, or scroll down the list, to locate the dataset you are searching for (AccountingProdAmts, in this example).<\/td>\n <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n3. Click on the dataset query, in the right panel.<\/td>\n <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n4. Click OK<\/strong>.<\/td>\n <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\nThe selected name appears in the Dataset Query<\/em> edit box.<\/td>\n <\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Step 3 b)<\/strong> Set Filter Column, Filter Value and Value Column, where applicable.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n
\u00a0<\/td>\n1. In the Filter Column<\/strong> text box type a column name from the dataset result set, as shown in the preview data (or set a variable<\/a>).<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n2. In the Filter Value<\/strong> text box, type a value from the dataset result set (as shown in the preview data), matching one of the values from the filter column (or set a variable<\/a>).<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\n3. In the Value Column<\/strong> text box, type a column name from the dataset result set (or set a variable<\/a>).<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\nNote<\/strong> how the Filter Column and Value Column are assigned actual column names, as shown in the preview data. Filter Value uses an actual value: \u2018Apr\u2019, from the \u2018MTH\u2019 column.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Step 3 c)<\/strong> If there are Dataset Parameters, type a value in each one\u2019s corresponding text box (or set a variable<\/a>).<\/p>\n

\"\"<\/a><\/p>\n

Step 3 d)<\/strong> Click Preview<\/strong> to view the dataset results. This is useful if you want to see column names and values, for Filtering<\/em>.<\/p>\n

The Dataset Preview<\/strong> window opens, displaying the result set for the selected query dataset and parameters.<\/p>\n

\"\"<\/a><\/p>\n

The Data Label Value property is configured, and the resulting data is displayed in the Data Label component.<\/p>\n

The screenshot below shows how filtering is used to locate a single data point.<\/p>\n

\"\"<\/a><\/p>\n

Step 4.<\/strong> Click the configured drop-down list, to close it.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\n

Using Ad hoc Calculation Data<\/h3>\n

Below is an example of what a property\u2019s ad hoc calculation<\/em> configuration looks like.<\/p>\n\n\n\n
\n\n\n\n\n
\n
\n\n\n\n\n\n\n\n\n\n\n
1. Component Property<\/strong>:<\/p>\n

This is the property that uses the data. In the example used, the data from two calculations using tags is available for the chart.<\/p>\n<\/td>\n<\/tr>\n

2. Data Categories<\/strong>:<\/p>\n

The selected category is highlighted, with details shown in the panel below the categories tab.<\/p>\n<\/td>\n<\/tr>\n

3. Calculations<\/strong>:<\/p>\n

Each calculation sources a range of data (for the selected time range, defined by Start Time and End Time) for this component\u2019s property.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single calculation, and this is for a single point in time.<\/p>\n<\/td>\n<\/tr>\n

4. Sample Method<\/strong> and Sample Interval<\/strong>:<\/p>\n

Sample Method and Sample Interval are used to define the method (e.g. Average<\/em>) and the interval (e.g. 3600 - measured in seconds<\/em>) that tag and\/or attribute data within any calculations is collected for this component.<\/p>\n<\/td>\n<\/tr>\n

5. Start Time<\/strong> and End Time<\/strong>:<\/p>\n

These times specify the request interval<\/em> for data (tags or attributes) that form part of the calculations.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single time: Time<\/strong>.<\/p>\n<\/td>\n<\/tr>\n

6. Item<\/strong>:<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), select an Item<\/strong>.<\/p>\n

The default is Value<\/em> - where values of any tags or attributes are used in the calculation. You can also select Confidence<\/em> from the drop-down list. Confidence is a measure (1 - 100) of the data's accuracy.<\/p>\n<\/td>\n<\/tr>\n

\n

Note<\/strong>: Click Preview<\/strong> to see the calculation results in a table.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to Select Ad hoc Calculation Data<\/h4>\n

This example uses a Chart component.<\/p>\n

Step 1. <\/strong>Click the drop-down list next to the Data property to open the Data Selector.<\/p>\n

\"\"<\/p>\n

The Data Selector<\/em> editor opens, for the Data<\/em> property.<\/p>\n

Step 2. <\/strong>Click the Ad-hoc<\/strong> category.<\/p>\n

\"\"<\/a><\/p>\n

Step 3. <\/strong>Select and configure the ad hoc calculation.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n

1. Type in a Calculation<\/strong> (or set a variable<\/a>). For example: {Silver} * 2<\/p>\n

See the table on the right, for more on ad hoc calculations. \"\"<\/p>\n<\/td>\n<\/tr>\n

2. Click the Add<\/em>\"\" button to the right of the Calculations<\/strong> box.<\/td>\n<\/tr>\n
Continue to add new calculations in this way.<\/em><\/td>\n<\/tr>\n
3. Select a Sample Method<\/a> to specify how Server should collect the attributes\/tags used in the calculations.<\/p>\n

Click the Options<\/em> \"\" button to the right of the Sample Method<\/strong> box, then select a sample method from the drop-down list: Average, Last Known Value, Linear Interpolate<\/em> or Raw<\/em>. (Or set a variable<\/a>.)<\/p>\n<\/td>\n<\/tr>\n

4. Select a Sample Interval<\/a> to specify which interval Server should use to collect the attributes\/tags used in the calculations.<\/p>\n

Click the Number<\/em> \"\" button to the right of the Sample Interval<\/strong> box, then type in a number. This is the interval, in seconds, and should be a multiple of 60. (Or set a variable<\/a>.)<\/p>\n<\/td>\n<\/tr>\n

5. Select a Start Time<\/a> (or set a variable<\/a>) to specify the start of the request interval<\/em> Server for should use for the attributes\/tags used in the calculations.<\/p>\n

Click the Time<\/em> \"\" button to the right of the Start Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n

6. Select an End Time<\/a> (or set a variable<\/a>) to specify the end of the request interval<\/em> Server for should use for the attributes\/tags used in the calculations.<\/p>\n

Click the Time<\/em> \"\" button to the right of the End Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n

7. Click Preview<\/strong> to see the tag results in a table.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\"\"Ad hoc Calculations<\/strong><\/td>\n<\/tr>\n
Syntax for an Ad hoc Calculation:<\/strong><\/td>\n<\/tr>\n
A basic calculation is a combination of tags and\/or attributes and numbers, with mathematical operators such as multiply *<\/strong>, add +<\/strong>, subtract -<\/strong> and divide %<\/strong>.<\/td>\n<\/tr>\n
Tags and Attributes in a Calculation:<\/strong><\/td>\n<\/tr>\n
Tags and attributes must be enclosed by curly braces {}<\/strong>.<\/td>\n<\/tr>\n
The attribute name is made up of the following components: Entity, Template, Attribute, Attribute Value, put together in this format: Entity[Template]:Attribute!Attribute Value<\/td>\n<\/tr>\n
Example of an attribute definition<\/em>: TWell 1[Oil Producing Well]:Casing Pressure!Actual<\/td>\n<\/tr>\n
Note: <\/em>If you choose not to specify a template, the primary template, current for the retrieved data's timestamp, is the one that gets used. (Primary templates, which are time aware<\/em>, are defined in Server. Read more about this here<\/a>.)<\/td>\n<\/tr>\n
Note: <\/em>If you choose not to specify an attribute value, the default<\/em> attribute value, current for the retrieved data's timestamp, is used. (Default attribute values, which are time aware<\/em>, are defined in Server. Read more about this here<\/a>.)<\/td>\n<\/tr>\n
Example of a basic calculation:<\/strong><\/td>\n<\/tr>\n
{TWell 1[Oil Producing Well]:Tubing Head Pressure!Target} - {TWell 1[Oil Producing Well]:Tubing Head Pressure!Actual}<\/td>\n<\/tr>\n
More on Calculations:<\/strong><\/td>\n<\/tr>\n
Refer to the article Mathematical Expressions<\/a> for syntax on some common mathematical functions to use in your calculations.<\/td>\n<\/tr>\n
For example, here is a calculation using the sqrt<\/strong> (square root) function<\/em>: sqrt({TWell 1:Casing Pressure} + 20)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To use this data, we've configured the chart to use data from the ad hoc calculations as follows: the {Silver}*2<\/em> column for a Line Series, the Max({Silver}, -900)<\/em> column for a second Line Series, and the Y Column<\/em>, and the Timestamp<\/em> column as the X Axis Column<\/em>.<\/p>\n

In the screenshot below, you can see the two calculation values {Silver}* 2<\/em> and Max({Silver}, -900)<\/em> plotted along the X Axis (Timestamp).<\/p>\n

\"\"<\/a><\/p>\n

Step 4.<\/strong> Click the configured drop-down list, to close it.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\n

Using Attribute Data<\/h3>\n

Here is an example of what a property\u2019s attribute<\/em> configuration looks like, where a set of data is required (such as the Data<\/em> for a Chart<\/em>). Note that there is a start time and an end time here for a range of dates, as well as the option to add multiple entities and attributes.<\/p>\n\n\n\n
\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n\n\n\n\n
1. Component Property<\/strong>:<\/p>\n

This is the property that uses the data. In the example used, data from two separate attributes, for two different entities is available for the chart. This data spans the time range specified by Start Time<\/em> and End Time<\/em>.<\/p>\n<\/td>\n<\/tr>\n

2. Data Categories<\/strong>:<\/p>\n

The selected category is highlighted, with details shown in the panel below the categories tab.<\/p>\n<\/td>\n<\/tr>\n

3. Entities and Attributes<\/strong>:<\/p>\n

One or more entities is specified here. One or more attributes for the defined entities is specified.<\/p>\n

Attributes are qualified by Template, Attribute<\/em>, and Attribute Value<\/em> names.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single Entity<\/strong> and a single Attribute<\/strong>.<\/p>\n<\/td>\n<\/tr>\n

4. Sample Method<\/strong> and Sample Interval<\/strong>:<\/p>\n

These are used to define the method (e.g. Average<\/em>) and the interval (e.g. 3600 - measured in seconds<\/em>) that attribute data is collected, for this component.<\/p>\n<\/td>\n<\/tr>\n

5. Start Time<\/strong> and End Time<\/strong>:<\/p>\n

These times specify the request interval<\/em> for the various attribute values.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single time: Time<\/strong>.<\/p>\n<\/td>\n<\/tr>\n

6. Item<\/strong>:<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), select an Item<\/strong>.<\/p>\n

The default is the attribute value's Value<\/em>. You can also select Name<\/em>, Timestamp<\/em>, or Confidence<\/em> (a measure, from 1 to 100, of the data's accuracy) from the drop-down list.<\/p>\n<\/td>\n<\/tr>\n

\n

Note<\/strong>: Click Preview<\/strong> to see the attribute values in a table.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to Select Attribute Data<\/h4>\n

The Chart requires a set of data, so we\u2019re using this as an example.<\/p>\n

Step 1. <\/strong>Click the drop-down list next to the Data property to open the Data Selector.<\/p>\n

\"\"<\/p>\n

The Data Selector<\/em> editor opens, for the Data<\/em> property.<\/p>\n

Step 2. <\/strong>Click the Attribute<\/strong> category.<\/p>\n

\"\"<\/a><\/p>\n

Step 3. <\/strong>Select and configure the attribute.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
1. Type in an Entity<\/strong> name (or set a variable<\/a>).<\/p>\n

Click the Entities<\/em> \"\" button to the right of the Entities<\/strong> box, then start typing an entity name in the Entities<\/strong> box. As you type, a list of matching names appears. Click to select an entity from the list.<\/p>\n<\/td>\n<\/tr>\n

2. Click the Add<\/em> \"\" button to the right of the Entities<\/strong> box.<\/td>\n<\/tr>\n
Continue to add new entities in this way.<\/em><\/td>\n<\/tr>\n
3. Click the Add<\/em> \"\" button to the right of the Attributes<\/strong> label, to add attributes.<\/td>\n<\/tr>\n
4. In the Template<\/strong> box, type in a Template<\/em> name. As you type, a list of matching names appears. Click to select a template from the list.<\/td>\n<\/tr>\n
5. In the Attribute<\/strong> box, type in an Attribute<\/em> name. As you type, a list of matching names appears. Click to select an attribute from the list.<\/p>\n

The current default attribute value appears in the Attribute Value<\/strong> box.<\/p>\n<\/td>\n<\/tr>\n

6. To change the default Attribute Value<\/em>, type a new Attribute Value<\/em> into the Attribute Value<\/strong> box. As you type, a list of matching names appears. Click to select an attribute value from the list.<\/td>\n<\/tr>\n
7. Select a Sample Method<\/a> (or set a variable<\/a>) to specify how Server should collect the attribute data.<\/p>\n

Click the Options<\/em> \"\" button to the right of the Sample Method<\/strong> box, then select a sample method from the drop-down list: Average, Last Known Value, Linear Interpolate<\/em> or Raw<\/em>. (Or set a variable<\/a>.)<\/p>\n<\/td>\n<\/tr>\n

8. Select a Sample Interval<\/a> (or set a variable<\/a>) to specify which interval Server should use to collect the attribute data.<\/p>\n

Click the Number<\/em> \"\" button to the right of the Sample Interval<\/strong> box, then type in a number. This is the interval, in seconds, and should be a multiple of 60.<\/p>\n<\/td>\n<\/tr>\n

9. Select a Start Time<\/a> (or set a variable<\/a>) to specify the start of the request interval<\/em> Server for should use for the attribute.<\/p>\n

Click the Time<\/em> \"\" button to the right of the Start Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n

10. Select an End Time<\/a> (or set a variable<\/a>) to specify the end of the request interval<\/em> Server for should use for the attributes.<\/p>\n

Click the Time<\/em> \"\" button to the right of the End Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n

\n

Note<\/strong>: Click Preview<\/strong> to see the tag results in a table.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\"\"Attributes<\/strong><\/td>\n<\/tr>\n
The attribute name is made up of the following components: Entity, Template, Attribute, Attribute Value, put together in this format:<\/td>\n<\/tr>\n
Entity[Template]:Attribute!Attribute Value<\/td>\n<\/tr>\n
Entity<\/strong><\/td>\n<\/tr>\n
Any entity<\/a> defined in the data model can be used here.<\/td>\n<\/tr>\n
Template<\/strong><\/td>\n<\/tr>\n
The entity's current primary template<\/a> is used, unless you define another template<\/a>.<\/td>\n<\/tr>\n
Attribute<\/strong><\/td>\n<\/tr>\n
Any attribute<\/a> that belongs to the specified template may be used.<\/td>\n<\/tr>\n
Attribute Value<\/strong><\/td>\n<\/tr>\n
The attribute's current default attribute value<\/a> is inserted. You can replace this with any other attribute value belonging to the attribute.<\/td>\n<\/tr>\n
Read more about Asset Modelling here<\/a> <\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This is what the previewed data looks like, for this example.<\/p>\n

\"\"<\/a>

Preview of Attribute Data<\/p><\/div>\n

To use this data, we've configured the chart to use the [Oil Producing Well]:Casing Pressure!Actual<\/em> column (just for entity TWell 10) for a Line Series Y Column<\/em>, and the Timestamp<\/em> column as the X Axis Column<\/em>.<\/p>\n

In the screenshot below, you can see the values for the attribute (TWell 10[Oil Producing Well]:Casing Pressure!Actual)<\/em> plotted along the X Axis (Timestamp)<\/em>.<\/p>\n

\"\"<\/a><\/p>\n

Step 4.<\/strong> Click the configured drop-down list, to close it.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\n

Using Tag Data<\/h3>\n

Below is an example of what a property\u2019s tag<\/em> configuration looks like, where a set of data is required (such as the Data<\/em> for a Chart<\/em>). Note that there is a start time and an end time here for a range of dates, as well as the option to add multiple tags.<\/p>\n\n\n\n
\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n\n\n\n\n
1. Component Property<\/strong>:<\/p>\n

This is the property that uses the data. In the example used, it is the Data<\/em> property, for the chart.<\/p>\n<\/td>\n<\/tr>\n

2. Data Categories<\/strong>:<\/p>\n

The selected category is highlighted, with details shown in the panel below the categories tab.<\/p>\n<\/td>\n<\/tr>\n

3. Tags<\/strong>:<\/p>\n

The tags used to source a a matrix of data for this component's Data<\/em> property.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single Tag<\/strong>.<\/p>\n<\/td>\n<\/tr>\n

4. Sample Method<\/strong> and Sample Interval<\/strong>:<\/p>\n

These are used to define the method (e.g. Average<\/em>) and the interval (e.g. 3600 - measured in seconds<\/em>) that tag data is collected, for this component's Data<\/em> property.<\/p>\n<\/td>\n<\/tr>\n

5. Start Time<\/strong> and End Time<\/strong>:<\/p>\n

These times specify the request interval<\/em> for the various tag values.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single time: Time<\/strong>.<\/p>\n<\/td>\n<\/tr>\n

Item<\/strong> (not shown here):<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), select an Item<\/strong>.<\/p>\n

The default is Value<\/em> - where values of any tags or attributes are used in the calculation. You can also select Confidence<\/em> from the drop-down list. Confidence is a measure (1 - 100) of the data's accuracy.<\/p>\n<\/td>\n<\/tr>\n

\n

Note<\/strong>: Click Preview<\/strong> to see the tag results in a table.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to Select Tag Data<\/h4>\n

Step 1. <\/strong>Click the drop-down list next to the Data property to open the Data Selector.<\/p>\n

\"\"<\/p>\n

The Data Selector<\/em> editor opens, for the Data<\/em> property.<\/p>\n

Step 2. <\/strong>Click the Tag<\/strong> category.<\/p>\n

\"\"<\/a><\/p>\n

Step 3. <\/strong>Select and configure the tags.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n
1. Type in a Tag<\/strong> name (or set a variable<\/a>).<\/p>\n

Click the Tags<\/em> \"\" button to the right of the Tags<\/strong> box, then start typing a tag name. As you type, a list of matching names appears. Click to select a tag from the list.<\/p>\n<\/td>\n<\/tr>\n

2. Click the Add<\/em> \"\" button to the right of the Tags<\/strong> box.<\/td>\n<\/tr>\n
Continue to add new tags in this way.<\/em><\/td>\n<\/tr>\n
3. Select a Sample Method<\/a> (or set a variable<\/a>) to specify how Server should collect the tag data.<\/p>\n

Click the Options<\/em> \"\" button to the right of the Sample Method<\/strong> box, then select a sample method from the drop-down list: Average, Last Known Value, Linear Interpolate<\/em> or Raw<\/em>. (Or set a variable<\/a>.)<\/p>\n<\/td>\n<\/tr>\n

4. Select a Sample Interval<\/a> (or set a variable<\/a>) to specify which interval Server should use to collect the tag data.<\/p>\n

Click the Number<\/em> \"\" button to the right of the Sample Interval<\/strong> box, then type in a number. This is the interval, in seconds, and should be a multiple of 60.<\/p>\n<\/td>\n<\/tr>\n

5. Select a Start Time<\/a> (or set a variable<\/a>) to specify the start of the request interval<\/em> for the tag data.<\/p>\n

Click the Time<\/em> \"\" button to the right of the Start Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n

6. Select an End Time<\/a> (or set a variable<\/a>) to specify the end of the request interval<\/em> for the tag data.<\/p>\n

Click the Time<\/em> \"\" button to the right of the End Time<\/strong> box, then select a date and time from the date time picker.<\/p>\n<\/td>\n<\/tr>\n

7. Click Preview<\/strong> to see the tag results in a table.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n
\n\n\n\n
\n\n\n\n\n\n\n
\"\" Tags<\/strong><\/td>\n<\/tr>\n
A tag is a time series data item, that has not<\/em> been modelled into a hierarchy.<\/td>\n<\/tr>\n
A tag can be referenced by an Attribute Value<\/a>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This is what the previewed data looks like, for this example.<\/p>\n

\"\"<\/a>

Preview of Tag Data<\/p><\/div>\n

The Chart's Data property is configured, and the resulting data is available for use in the chart component.<\/p>\n

To use this data, we've configured the chart to use the tag data as follows: the Silver<\/em> column for a Line Series, the Goldenrod<\/em> column for a second Line Series, and the Timestamp<\/em> column as the X Axis Column<\/em>.<\/p>\n

In the screenshot below, you can see the values for the two tags, Silver<\/em> and Goldenrod<\/em>, plotted along the X Axis (Timestamp).<\/p>\n

\"\"<\/a><\/p>\n

Step 4.<\/strong> Click the configured drop-down list, to close it.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\n

Using Value Data<\/h3>\n

Here is an example of what a property\u2019s value<\/em> configuration looks like, where a list of data is required (such as the Option Values<\/em> for an Option Links<\/em>) component.<\/p>\n\n\n\n
\n\n\n\n
\n

\"\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n
1. Component Property<\/strong>:<\/p>\n

This is the property that uses the data. In the example used, it is the Option Values<\/em>, used by the Option Links component.<\/p>\n<\/td>\n<\/tr>\n

2. Data Categories<\/strong>:<\/p>\n

The selected category is highlighted, with details shown in the panel below the categories tab.<\/p>\n<\/td>\n<\/tr>\n

3. Values<\/strong>:<\/p>\n

A set of values. These can be numerical or text.<\/p>\n

Variation:<\/strong> For component properties where only a single point of data is used (such as the Data Label's Value<\/em>), you can only enter a single Value<\/strong>.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to Select Value Data<\/h4>\n

Step 1. <\/strong>Click the drop-down list next to the Option Values property to open the Data Selector.<\/p>\n

\"\"<\/a><\/p>\n

The Data Selector<\/em> editor opens, for the Option Values<\/em> property.<\/p>\n

Step 2. <\/strong>Click the Value<\/strong> category.<\/p>\n

\"\"<\/a><\/p>\n

Step 3. <\/strong>Select and configure the values.<\/p>\n

\"\"<\/a><\/p>\n

Step 3 a)<\/strong> Click the CSV (comma separated values)<\/em> \"\" button to the right of the Values<\/strong> box, then type in a number or string. (Or set a variable<\/a>.)<\/p>\n

Step 3 b)<\/strong> Click the Add<\/em> \"\" button to the right of the Values<\/strong> box, or press the Enter<\/em> key.<\/p>\n

Step 3 c)<\/strong> Keep adding values in this way, until you have all the value options that you want to use.<\/p>\n

The Option Links Option Values<\/em> property is configured, and the resulting data is displayed in the Option Links component.<\/p>\n

\"\"<\/a><\/p>\n

Step 4.<\/strong> Click the configured drop-down list, to close it.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Many of the Explorer components are used for displaying data. For example, the data label, charts, the dataset table, target bars, meters.
\nLearn how to select and define data within Explorer Studio, using the data selector editor, for versions 4.3.2 and earlier of P2 Explorer.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":18972,"parent":18917,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[419,109,100,257,175],"class_list":["post-9553","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-add-data","tag-attributes","tag-calculations","tag-datasources","tag-tags","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=9553"}],"version-history":[{"count":2,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9553\/revisions"}],"predecessor-version":[{"id":44473,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9553\/revisions\/44473"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/18917"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/18972"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=9553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=9553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=9553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}