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

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

Overview<\/h3>\n

The Target Bar shows a numeric value as a bar in relation to a target marker. By default, the bar is red when the value is below target, or grey when the value is at or above target.<\/p>\n

The following diagram shows a target bar being configured:<\/p>\n

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

\u00a0<\/div>\n\n\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 the bar fill.<\/td>\n<\/tr>\n
Target Column<\/strong>:<\/td>\nThe column from the dataset that determines the vertical black target bar.<\/td>\n<\/tr>\n
Max Column:<\/strong><\/td>\nThe column from the source data that determines the maximum value that the bar should have. This can be above the target value. For example, you may have a sales target of 90% but the maximum would be 100%.<\/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 Field.<\/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<\/strong>:<\/td>\nSelect this check box to invert the good and bad thresholds, so that lower is good and higher is bad.<\/td>\n<\/tr>\n
Percentage<\/strong>:<\/td>\nSelect this check box if the thresholds are expressed in percentages.<\/td>\n<\/tr>\n
Decimals<\/strong>:<\/td>\nThe number of decimal points for the actual value displayed in the tooltip.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

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

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

\"targetbarfinal\"<\/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 Bar\u00a0That Displays Planned\u00a0vs Actual<\/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