{"id":8715,"date":"2015-12-16T11:02:24","date_gmt":"2015-12-16T03:02:24","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=8715"},"modified":"2025-08-25T18:21:54","modified_gmt":"2025-08-25T10:21:54","slug":"creating-a-trend-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/trends\/creating-a-trend\/creating-a-trend-4-3-2\/","title":{"rendered":"Creating a Trend (4.3.2)"},"content":{"rendered":"

<\/p>\n

Related: See Creating a Trend (4.3.1)<\/span> for help on an earlier version of the Trend.<\/p>\n

Overview<\/span><\/h3>\n

A trend displays time-series data, such as tags and attributes, as a line chart over a selected period of time.<\/p>\n

To create a trend, you need to open a new blank trend and then add tag or attribute data to this. The screenshot below shows a new trend, with two attributes:<\/p>\n\n\n\n\n\n
Trend Ribbon Tab<\/strong><\/td>\nUse the buttons on this tab to refresh, save, or share the trend. (Refresh, Save, Snapshot, Share Link, Print, Export CSV<\/em>) as well as a link to the online help (Help<\/em>) and toggle buttons to show or hide elements of the Trend (Controls, Range Selector<\/em> and Trace Table<\/em>).<\/td>\n<\/tr>\n
Controls<\/strong><\/td>\nThe selections you make affect the time range of the chart, as well as how P2 Server fetches the data<\/a>, and how the trace line is displayed.<\/td>\n<\/tr>\n
 <\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n
Time Range<\/em>:<\/td>\nThis defines the start and end date and time of your trend.<\/td>\n<\/tr>\n
Now<\/em>:<\/td>\nIf selected, then this replace Time Range<\/em> with Duration<\/em> and Refresh Rate<\/em>.<\/td>\n<\/tr>\n
Sample Method<\/em>:<\/td>\nThis is the method (for example, average) that P2 Server uses to collect your trend data.<\/td>\n<\/tr>\n
Sample Interval<\/em>:<\/td>\nThis is the interval (for example, 1 week) that P2 Server uses to collect your trend data.<\/td>\n<\/tr>\n
Y Scale Type<\/em>:<\/td>\nYou can choose Log (uses logarithmic data points) or Linear (uses actual data points).<\/td>\n<\/tr>\n
Hairlines<\/em>:<\/td>\nChoose the number of hairlines allowable on the trend (single, dual or multiple or none).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
Trace<\/strong><\/td>\nThe trace displays time-series data, such as tags, over a period of time (Time Range)<\/em>.<\/td>\n<\/tr>\n
Range Selector<\/strong><\/td>\nThe highlighted section in the range selector matches the start and end of the trend time range<\/em>. Use the range selector as a longer trend, to help identify highs and lows. You can select smaller periods within the range selector, to pick a new time range<\/em>.<\/td>\n<\/tr>\n
Trace Tables<\/strong><\/td>\nDrag and drop tags, attributes or attribute values into these tables (Left Axis and Right Axis) to include them in the trace.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

\n

Show\/Hide Trend Features<\/span><\/h3>\n

You change the trend view to allow more space for the trace lines.<\/p>\n

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

Click any of the buttons in the View<\/em> section of the Trend<\/strong> ribbon, to hide the respective sections: Controls, Range Selector, Trace Table.<\/p>\n

This is how the trend looks with all three areas hidden.<\/p>\n

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

Click a button again to show the relevant section.<\/p>\n

\n

The Trace Table<\/span><\/h3>\n

The trace table is divided into a left axis and a right axis section, and lists all attributes, tags and calculations in the trace.<\/p>\n

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

Click on the interactive symbols on the Left Axis Trace Table shown below, to learn more about the trace tables:<\/em><\/p>\n\n\n\n
\n

[imagemap id=\"8825\"]<\/p>\n<\/td>\n

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

Quick Reference:<\/em><\/p>\n\n\n\n\n\n\n\n
\"\"<\/td>\nData items here have a left axis. You can drag a data item to the Right Axis table to give it a right axis.<\/td>\n\"\"<\/a><\/td>\nThis is the trace data, and could be a tag or attribute name, with or without a calculation, or it could even be a fixed number, such as 99.<\/td>\n<\/tr>\n
\"\"<\/td>\nYou can click this button if you want to add a new trace by typing in a tag or attribute name.<\/td>\n\"\"<\/a><\/td>\nAny issues with the data or the data fetch are indicated by this error icon. Hover over the icon to see warning details.<\/td>\n<\/tr>\n
\"\"<\/td>\nTo change the Trace Colour<\/strong>, click and select one from the colour wheel.<\/td>\n\"\"<\/a><\/td>\nTo remove the trace from this trend, click the Remove<\/em> button.<\/td>\n<\/tr>\n
\"\"<\/td>\nTo change the Trace Style<\/strong>, click and select one from the styles wheel (e.g. choose dot).<\/td>\n\"\"<\/td>\nYou can edit or add new trace data by typing in this box. Attributes and tags must be enclosed by curly braces{}.<\/td>\n<\/tr>\n
\"\"<\/td>\nTo hide the trace, de-select this box.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Watch the video below, to see some of the trace table functionality in action.<\/p>\n\r\n\t\r\n\t

\n

Tutorial<\/span><\/h3>\n

In this tutorial we\u2019ll add a new trend, and then drop some attributes into the Tags List, to create a trace. We'll then experiment with features of the resulting trend.<\/span><\/p>\n

\"\"

Drop values onto the trend<\/p><\/div>\n

Follow the step-by-step instructions, below.<\/p>\n

\n

Step by Step: Adding a New Trend<\/h3>\n

First we'll open a new trend and put some data on there. Next, we'll experiment with changing selections and using the range selector, and then we'll add a hairline with comments. Next, we'll save the trend. And finally, we'll locate and open the saved trend.<\/p>\n

You will need to search for attributes or tags within your own environment, to follow this exercise.<\/p>\n

Step 1. Adding a New Trend<\/h4>\n

Open the Home<\/strong> tab on the Explorer ribbon, and click New Trend<\/strong>.<\/p>\n

\"\"<\/p>\n

A new Blank Trend<\/em> opens in Explorer, with the following defaults:<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n
Time Range<\/em>:<\/td>\nFrom<\/em> 1 week To<\/em> {current date and time}<\/td>\n<\/tr>\n
Now<\/em>:<\/td>\nNot selected<\/td>\n<\/tr>\n
Sample Method<\/em>:<\/td>\nAverage<\/td>\n<\/tr>\n
Sample Interval<\/em>:<\/td>\n1 day<\/td>\n<\/tr>\n
Y Scale Type<\/em>:<\/td>\nLinear<\/td>\n<\/tr>\n
Hairlines<\/em>:<\/td>\nSingle<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
\n

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

Note that the Page<\/strong> tab on the ribbon is replaced by the Trend<\/strong> tab.<\/p>\n

Step 2. Adding a Trace<\/h4>\n

Related: Searching for Tags and Hierarchy Attributes<\/a><\/p>\n

To trend an attribute or tag, you can either drag it onto the trace (where it's automatically added to the Left Axis) or drag it onto the trace table (Left Axis or Right Axis) - or you can click Add Trace<\/strong> on the trace table (Left Axis or Right Axis), and type in a tag or attribute name, surrounded by curly braces {}.<\/p>\n

Dragging an Attribute onto the Trend<\/strong><\/p>\n

To add an attribute to the Trend Table<\/em>: Open the hierarchy navigator, select a hierarchy, then search for the attribute you want to trace and drag it onto the trend, or into the trace table. Follow the steps below:<\/p>\n

1. Click the View<\/strong> tab on the Ribbon, then click Hierarchy<\/strong>.<\/p>\n

\"\"<\/a>

Click Hierarchy<\/p><\/div>\n

2. Select a hierarchy from the drop-down list, navigate through the hierarchy to find your entity, and click the Attributes<\/em> button to the right of that entity.<\/p>\n

In our example tutorial, we select the Test Time Series Hierarchy<\/em>, and navigate to the TWell1 <\/em>entity: TOrganisation 1>TRegion 1>TArea 1>TField 1>TWell 1<\/em><\/p>\n

\"\"

Search the Hierarchy<\/p><\/div>\n

3. Select an attribute from one of the templates, and drag it onto the Trace Table<\/em>. Now add another one in the same way.<\/p>\n

The attributes used in our example tutorial are: TWell 1[Oil Producing Well]:Tubing Head Pressure!Actual<\/em> and TWell 1[Oil Producing Well]:Tubing Head Pressure!Target<\/em>.<\/p>\n

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

Dropping a Tag into the Trace Table<\/em><\/strong><\/p>\n

1. Click Tags<\/strong> on the View<\/strong> tab.<\/p>\n

2. Search for tags in the tags list that appears on a panel on the left. Drag and drop a tag onto the Tags List.<\/p>\n

Typing Values into the Trace Table<\/em><\/strong><\/p>\n

You can type a known tag name or attribute name surrounded by curly brackets {}<\/strong>, for example: {silver} in the Tags List<\/em>, and then press enter.<\/p>\n

Calculations in the Trace Table<\/em><\/strong><\/p>\n

You can also type in a calculation, with the tag or attribute also surrounded by curly brackets {}<\/strong>, for example: {TWell 1:Tubing Head Pressure} + 20, or add a calculation to to an attribute or tag that you dragged onto the trend, by editing the value in the Trace Table.<\/p>\n

Note that the attribute in this list only requires the entity name and attribute name (primary template and default attribute value are implicit values, but can optionally be added anyway.).<\/p>\n

The video below demonstrates how you would type in a tag name, and how to add a calculation to an attribute in the trace table.<\/p>\n\r\n\t\r\n\t

 <\/p>\n

Step 3. Using the Trend Controls<\/h4>\n

In this step, we'll experiment with changing the Time Range<\/em>, we'll select Now<\/em>, we'll update the Sample Method<\/em> and Sample Interval<\/em>, the Y Scale Type<\/em> and the number of Hairlines<\/em>. Note that the selections affect how much data is returned, thus affecting the time taken to render the trend.<\/p>\n

Watch the video below to see how the changing controls affect the trend.<\/p>\n\r\n\t\r\n\t

 <\/p>\n

Step 3.1. Changing the Time Range<\/strong><\/p>\n

The defaults are: From 1 week<\/em> to current date and time<\/em><\/p>\n

Select 3 months<\/em> from the Time Range<\/strong> drop-down list. Note how the trend range now extends for three months.<\/p>\n

\"\"<\/a>

A Trend Spanning 3 Months<\/p><\/div>\n

Note: <\/strong> If you select a long time range (such as three months or longer) there will be a lot of data returned, which will take longer than if you select a short range, such as 1 week<\/em>.<\/p>\n

Step 3.2. Selecting Now<\/strong><\/p>\n

By default Now<\/em> is not selected.<\/p>\n

Select the Now<\/em> checkbox.<\/p>\n

\"\"<\/a>

A Trend Spanning 1 week to Now, Refreshed every 1 minute<\/p><\/div>\n

Note:<\/strong> The time range is replaced by Duration<\/em> and Refresh Rate<\/em>.<\/p>\n

Duration<\/em> is the time leading up to current date and time. Select a Refresh Rate<\/em>; this sets the rate at which Explorer refreshes the data as time moves forward, each time getting the current date and time for 'Now'.<\/p>\n

Step 3.3. Changing the Sample Method<\/strong><\/p>\n

The default is: Average<\/em><\/p>\n

Select Linear Interpolate<\/em> from the Sample Method<\/a><\/strong> drop-down list.<\/p>\n

\"\"<\/a>

Trend with Linear Interpolate Sample Method<\/p><\/div>\n

Note:<\/strong> Raw<\/em> sample method will usually return the highest number of data points, potentially affecting performance.<\/p>\n

Step 3.4. Changing the Sample Interval<\/strong><\/p>\n

The default is: 1 day<\/em><\/p>\n

Select 2 weeks<\/em> from the Sample Interval<\/a><\/strong> drop-down list.<\/p>\n

\"\"<\/a>

Trend with 2 Weeks Sample Interval<\/p><\/div>\n

Note:<\/strong> The shorter your interval (for example 5 seconds<\/em>) the more data required, potentially affecting performance.<\/p>\n

Step 3.5. Changing the Y Scale Type<\/strong><\/p>\n

The default is: Linear<\/em><\/p>\n

Select Log<\/em> from the Y Scale Type<\/strong> drop-down list.<\/p>\n

\"\"<\/a>

Trend with a Y Scale Type of Log<\/p><\/div>\n

Note:<\/strong> Negative or zero values cannot render in the logarithmic scale type.<\/p>\n

Step 3.6. Changing the Hairlines<\/strong><\/p>\n

The default is: Single<\/em><\/p>\n

Select Dual<\/em> from the Hairlines<\/strong> drop-down list.<\/p>\n

\"\"<\/a>

Trend with Dual Hairlines<\/p><\/div>\n

Note:<\/strong> You can now add two hairlines to the trend.<\/p>\n

Note:<\/strong> Other options are None<\/em> and Multiple<\/em> (which allows you to add up to five hairlines).<\/p>\n

Step 4. Changing your Time Selection with the Range Selector<\/h4>\n

The Range Selector<\/em>, found below the Trace<\/em>, works together with the Time Range<\/em> selectors to set your trend time range. By default, the range selector has a highlighted section that matches the time range set by the date pickers, with an equal amount of time shown before and after.<\/p>\n

\"\"<\/a>

The Trend Range Selector<\/p><\/div>\n

Resizing the highlighted section<\/strong><\/p>\n

1. Hover the mouse over the left or right edge of the highlighted section, until you see the mouse horizontal resize<\/em> pointer.<\/p>\n

2. Now click and drag to left or right. Note how the trend start and end time changes.<\/p>\n

Moving the highlighted section<\/strong><\/p>\n

1. Hover the mouse over the central portion of the highlighted section, until you see the mouse move<\/em> pointer.<\/p>\n

2. Now click and drag the whole highlighted section to left (earlier) or right (later). Note how the trend start and end time changes.<\/p>\n

Changing the Range Selector start and end dates<\/strong><\/p>\n

Click on the left or right arrow to move the start and end date of the range selector. Note that the dates on the highlighted section do not change; the highlighted section just moves across (to left or right) in relation to the changing start and end dates of the range selector.<\/p>\n

\"\"<\/a>

Moving the Trend Range Selector Start and End dates<\/p><\/div>\n

 <\/p>\n

The video below demonstrates the use of the range selector. Clicking Refresh<\/strong> resets the time range.<\/p>\n\r\n\t\r\n\t

 <\/p>\n

Step 5. Adding a Hairline and Comments<\/h4>\n

Add a hairline to view values (if any) for all trended tags at a particular point in time. You can leave a comment for a trended tag at the hairline point, or view and reply to other comments.<\/p>\n

\"\"<\/a>

Trend Hairline<\/p><\/div>\n

New Hairline<\/strong><\/p>\n

Click a point on the trace to get a hairline, a vertical line marking out this time, with an information box to the side.<\/p>\n

To remove the hairline, close information box (click X on the top right corner).<\/p>\n

To move the hairline, either drag it along the trace, or add a click another point on the trace.<\/p>\n

Hairline Information<\/strong><\/p>\n

The Date and Time is displayed at the top of the information box.<\/p>\n

Each tag is identified by its trace legend and its full name. The tag value (if any) is displayed to the right, followed by a comment icon.<\/p>\n

Adding a Comment<\/strong><\/p>\n

To add or view comments, click the comment icon for a tag. See below for more on comments.<\/p>\n

Step 6. Adding, Viewing and Replying to Comments on a Trend Tag<\/h4>\n

Comments can be added to tags on a trend. You can reply to comments, locate comments on a trace, and even search for a range of comments by changing the search times in a comment window for a particular tag. All tag comments within the range are listed in the comment window, in order of most recent<\/p>\n

Note that you cannot remove comments.<\/p>\n

\"\"<\/a>

Tag Comment Search Times<\/p><\/div>\n

Step 6.1. Adding a Comment<\/strong><\/p>\n

1. Click the comment icon on the hairline information box, to open a blank comment window.<\/p>\n

2. Type in a comment, then click Add<\/strong>.<\/p>\n

\"\"<\/a>

Add a Comment<\/p><\/div>\n

Step 6.2. Replying to Comment<\/strong><\/p>\n

Comments are indicated on the trace by a vertical, dotted line.<\/p>\n

1. Click the comment icon to open the comment window. (You can click the comment icon again to close the comment window.)<\/p>\n

\"\"<\/a>

Locate and Open the Comment<\/p><\/div>\n

2. In the comment window, click reply<\/em>, then type in a response and click Add<\/strong>.<\/p>\n

\"\"<\/a>

Reply to the Comment<\/p><\/div>\n

Step 7. Saving Your Trend<\/h4>\n

Open the Trend<\/strong> tab on the Explorer ribbon, and click Save<\/strong>.<\/p>\n

\"\"

Click Save on the Trend Ribbon<\/p><\/div>\n

The Save Trend<\/em> window opens. Type in a Name<\/em> for your trend, and save to My Workspace<\/em> or select a Workspace<\/em> from the drop-down list.<\/p>\n

\"\"

Save Trend<\/p><\/div>\n

Step 8. Search for a Trend<\/h4>\n

Now that you have created and saved your trend, here is how you can find it again:<\/p>\n

Searching for a Trend by Name<\/strong><\/p>\n\n\n\n\n\n
Search button on the Home ribbon<\/em><\/td>\nSearch results are listed in the Search Panel<\/em><\/td>\n<\/tr>\n
\n

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

\n

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

\n\n\n\n\n
1<\/strong>:<\/td>\nOpen the Home<\/strong> tab on the Explorer ribbon, and click Search<\/strong>.<\/td>\n<\/tr>\n
2<\/strong>:<\/td>\nType all or part of the trend name in the Search<\/em> box, then press enter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n\n
3<\/strong>:<\/td>\nRefine your search text if necessary, then press enter in the Search Box<\/em>.<\/td>\n<\/tr>\n
4<\/strong>:<\/td>\nScroll through the search results, then select the trend you are searching for.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Searching for a Trend in a Workspace<\/strong><\/p>\n

Here is an alternative way of finding your trend.<\/p>\n\n\n\n
\n

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

\n\n\n\n\n\n\n\n
1<\/strong>:<\/td>\nOpen the Home<\/strong> tab on the Explorer ribbon, and click Workspaces<\/strong>.<\/td>\n<\/tr>\n
2<\/strong>:<\/td>\nClick the workspace that contains the trend (for example, My Workspace<\/em>).<\/td>\n<\/tr>\n
3<\/strong>:<\/td>\nClick Trends<\/strong> in the main area.<\/td>\n<\/tr>\n
4<\/strong>:<\/td>\nType the trend name in the Filter Trends<\/em> search box.<\/td>\n<\/tr>\n
5<\/strong>:<\/td>\nClick on the trend thumbnail to open it.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

An Explorer trend displays time-series data, such as tags and attributes, over a selected period.
\nThe trend can have multiple hairlines, and you can add comments to the trended tag or attribute.
\nThis help article describes the trend components, with a tutorial. <\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":5031,"parent":38346,"menu_order":11,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[663,326,316],"class_list":["post-8715","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-comment","tag-hairlines","tag-trends","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/8715","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=8715"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/8715\/revisions"}],"predecessor-version":[{"id":47160,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/8715\/revisions\/47160"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/38346"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/5031"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=8715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=8715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=8715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}