{"id":15228,"date":"2016-05-24T11:38:15","date_gmt":"2016-05-24T03:38:15","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=15228"},"modified":"2017-12-14T14:38:45","modified_gmt":"2017-12-14T06:38:45","slug":"target-variance-bar-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/target-variance-bar\/target-variance-bar-4-3-2\/","title":{"rendered":"Target Variance Bar (4.3.2)"},"content":{"rendered":"\n

This article applies to the Target Variance Bar in versions 4.3.2 and earlier of P2 Explorer.\u00a0For help on the latest version, see Target Variance Bar<\/a>.<\/p>\n

Overview<\/h3>\n

The Target Variance Bar shows a variance value from a target as a bar. By default, the bar is red when the variance\u00a0is below the target, or grey when the variance\u00a0is at or above the target.<\/p>\n

The following diagram shows a Target Variance Bar being configured:<\/p>\n

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

\u00a0<\/div>\n\n\n\n\n\n\n\n\n\n\n\n
Source Data<\/strong>:<\/td>\nThe\u00a0dataset from which the values are obtained.<\/td>\n<\/tr>\n
Actual Column:<\/strong><\/td>\nThe column from the dataset that determines the actual value used for calculating the variance from a target.<\/td>\n<\/tr>\n
Target Column<\/strong>:<\/td>\nThe column from the dataset that determines the value used for calculating the variance from this target.<\/td>\n<\/tr>\n
Max Variance Column:<\/strong><\/td>\nThe column from the source data that determines the maximum variance value. This determines the proportion of the bar that is filled. It is commonly used to align multiple Target Variance Bars to the same scale so that comparisons can be made easier.<\/p>\n

For example, if you had 3 Target Variance Bars in a table, with max variances of 20, 40, and 60, you would set the max variance for all of them to 60.<\/p>\n<\/td>\n<\/tr>\n

Filter Column<\/strong>:<\/td>\nThe column of the dataset that provides the values that will be assessed. This is used in conjunction with the Filter Value<\/a>.<\/td>\n<\/tr>\n
Filter Value<\/strong>:<\/td>\nThe row of the dataset that provides the values that will be assessed.<\/td>\n<\/tr>\n
Colours<\/strong>:<\/td>\nThe number of colours specified should be the number of Thresholds + 1. The order in which the colours are specified should be the same order that the thresholds are specified.<\/td>\n<\/tr>\n
Thresholds<\/strong>:<\/td>\nThe values at which the bar colour should change. The highest threshold value should be less than the value of Max Variance.<\/p>\n

By default, the thresholds are set to 60% under, 30% under, and 0%. So if the actual value is more than 60% under target, the colour of the bar is deep red. At 0% (i.e. the target has been met), the colour changes to grey.<\/p>\n<\/td>\n<\/tr>\n

Reverse Colours<\/strong>:<\/td>\nSelect this check box to invert the colour thresholds.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

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

The Target Variance Bar\u00a0is a useful component to display variances of production from target. In this topic, we\u2019ll show you how to use the Target Variance Bar\u00a0to display the variance from planned water production for a selected well. This is often used in production summary reports.<\/p>\n

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

Let\u2019s look at how we\u2019re actually going to do this, step-by-step.<\/p>\n

\n

Step by Step: Creating a Target Variance Bar<\/span><\/span><\/span><\/span><\/span><\/h3>\n

Before you start, open a new tab in Explorer and click the \u201cCreate a New Page in Studio Mode\u201d thumbnail.\u00a0Choose the grid<\/a>\u00a0layout \u2013 you can adjust the rows and columns if you like but it\u2019s not important for this exercise.<\/p>\n

You will need to adjust the configuration to suit your data at your site.<\/p>\n

Step 1. Add\u00a0the source data<\/strong><\/p>\n

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

Before we can display any\u00a0data on the page, \u00a0we need to add the source data.<\/p>\n