{"id":2702,"date":"2015-03-23T19:36:01","date_gmt":"2015-03-23T11:36:01","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=2702"},"modified":"2018-01-04T13:31:39","modified_gmt":"2018-01-04T05:31:39","slug":"add-time-series-data","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/add-time-series-data\/","title":{"rendered":"Adding Time Series Data"},"content":{"rendered":"\n

This article applies to versions 4.3.2 and earlier of P2 Explorer. For help on later versions, read the Data Selector<\/a> article.<\/p>\n

Overview<\/h3>\n

Your dataset uses a datasource to connect to a database or other source of data. You need to add the dataset<\/a> that you require and then configure the parameters so that you can use the returned data on your page.<\/p>\n

\"timeseriesconfig\"<\/a><\/p>\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong>:<\/td>\nUnlike tabular datasets<\/a> where the name is based on an SQL query, Time Series data does not have a default name. You should give the data an appropriately descriptive name.<\/td>\n<\/tr>\n
Using<\/strong>:<\/td>\nTime Series data can be based on either tags or entities.<\/td>\n<\/tr>\n
Tags<\/strong>:<\/td>\n\n

Specify one or more tags for which to display data. You can choose the list these tags explicitly or you can subscribe to an event.<\/p>\n<\/td>\n<\/tr>\n

Entities<\/strong>:<\/td>\n\n

Specify one or more entities for which to display data. You can choose the list these entities explicitly or you can subscribe to an event. You can further restrict the entities to ones that are associated with a specific template (e.g. Oil Producing Well) and that have a specific attribute (e.g. tubing head pressure).<\/p>\n<\/td>\n<\/tr>\n

Group by<\/strong>:<\/td>\n\n

You can choose to group the data by time or entity, or you can choose no grouping.<\/p>\n<\/td>\n<\/tr>\n

Parameters<\/strong>:<\/td>\n\n

Parameters are used to provide the time series data with boundaries that determine the type of data and the frequency with which it is returned.<\/p>\n

SampleInterval<\/em><\/strong>: The frequency with which the data is collected. This is a number that is specified in seconds.<\/p>\n

SampleMethod<\/em><\/strong>: The way in which data is selected from a continuous stream. Available options:<\/p>\n

    \n
  • Raw<\/em>: Every single point of data between the specified start and end times is returned. This is often not desirable as it can result in large volumes of data that can slow the system down. Additionally, more data can be returned than is able to be rendered on the screen at the given resolution, resulting in illegible displays.<\/li>\n
  • Average<\/em>: The raw data is transformed by applying an average<\/em> function to the data. This transform returns a time-weighted average of the raw data over the specified SampleInterval.<\/li>\n
  • Linear Interpolate<\/em>: The raw data is transformed by applying a linear interpolation<\/em> function to the data.<\/li>\n
  • Last Known Value<\/em>: The raw data is transformed by applying a last known value<\/em> function to the data. This transform returns the last known raw value at the end of each SampleInterval.<\/li>\n<\/ul>\n

    StartTime<\/strong><\/em>: Only data between (and including) the specified start and end times will be returned.<\/p>\n

    EndTime<\/strong><\/em>: Only data between (and including) the specified start and end times will be returned.<\/p>\n<\/td>\n<\/tr>\n

Preview<\/strong>:<\/td>\n\n

After you have specified all your settings and parameters, you should be able to see some data. Click Preview <\/strong>to display the data in a table. You can keep this window open as you build your page.<\/p>\n<\/td>\n<\/tr>\n

Publish events from dataset<\/strong>:<\/td>\n\n

You can take a list or a single value from the dataset, and publish this as an event to be used by other controls on the page.<\/p>\n