{"id":15380,"date":"2016-06-15T08:33:41","date_gmt":"2016-06-15T00:33:41","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=15380"},"modified":"2017-12-07T09:32:01","modified_gmt":"2017-12-07T01:32:01","slug":"bullet-graph-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/bullet-graph-4-3-2\/","title":{"rendered":"Bullet Graph (4.3.2)"},"content":{"rendered":"<p class=\"page-subheading\"><\/p>\n<p class=\"left-bar\">This article applies to the Bullet Graph in versions 4.3.2 and earlier of P2 Explorer. For help on the latest version, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/\">Bullet Graph<\/a>.<\/p>\n<h3 class=\"page-subheading\">Overview<\/h3>\n<p class=\"intro-text\">The Bullet Graph is similar to a horizontal bar chart but allows users to\u00a0compare two values in relation to one another. For example, an actual value (represented by a horizontal bar) and a target value (represented by a vertical line).<\/p>\n<p class=\"intro-text\">The following diagram shows a Bullet Graph\u00a0being configured:<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bullet.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3322\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bullet-800x447.png\" alt=\"bullet\" width=\"800\" height=\"447\" \/><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"130\"><strong>Source Data<\/strong>:<\/td>\n<td>The dataset from which the bullet graph\u00a0sources its data.<\/td>\n<\/tr>\n<tr>\n<td><strong>Measure 1 Column - Measure 3 Column<\/strong>:<\/td>\n<td>The Columns that provide values for up to three different comparative segments, each represented by a grey section. This can be used to specify different thresholds, such as <em>good<\/em>, <em>OK<\/em>, and <em>bad<\/em>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Actual Column<\/strong>:<\/td>\n<td>The column in the dataset that provides the actual value of interest. This is represented in the bullet graph by the blue horizontal bar.<\/td>\n<\/tr>\n<tr>\n<td><strong>Target Column<\/strong>:<\/td>\n<td>The column in the dataset that provides the value that we are aspiring to reach. For example, a sales target. If the Actual Column is\u00a0expressed as a percentage, Target Column is not required. This is represented in the bullet graph by the black vertical line.<\/td>\n<\/tr>\n<tr>\n<td><strong>Filter Column<\/strong>:<\/td>\n<td>The column of the dataset that provides the values that will be assessed. This is used in conjunction with the <a title=\"Filter Column and Filter Value\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/filter-column-and-filter-value\/\">Filter Value<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Filter Value<\/strong>:<\/td>\n<td>The row of the dataset that provides the values that will be assessed.<\/td>\n<\/tr>\n<tr>\n<td><strong>Percent<\/strong>:<\/td>\n<td>Select this check box if the Actual Column value is expressed as a percentage.<\/td>\n<\/tr>\n<tr>\n<td><strong>Reverse<\/strong>:<\/td>\n<td>Select this check box to invert the Actual and Target Column\u00a0values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\">\u00a0<\/p>\n<hr \/>\n<h3 class=\"page-subheading\"><span id=\"Tutorial\">Tutorial<\/span><\/h3>\n<p class=\"intro-text\">The Bullet Graph is a useful component to display levels. In this topic, we\u2019ll show you how to use the Bullet Graph to display actual vs planned\u00a0production data for a selected well. This is often used in production summary reports. The background will be shaded to show the different measures.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3565\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png\" alt=\"bulletfinal\" width=\"441\" height=\"542\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png 441w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-122x150.png 122w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-39x48.png 39w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n<p class=\"intro-text\">Let\u2019s look at how we\u2019re actually going to do this, step-by-step.<\/p>\n<hr \/>\n<h3 class=\"page-subheading\"><span id=\"Step_by_Step_Creating_a_Target_LabelThat_Displays_Targetvs_Actual_Data\"><span id=\"Step_by_Step_Creating_a_MeterThat_Displays_Planned_vs_Actual_Data\"><span id=\"Step_by_Step_Creating_a_Tank_That_Displays_Stored_Oil_Volumes_for_aSelectedEntity\"><span id=\"Step_by_Step_Creating_a_Schematic_Using_Precision_Layout\"><span id=\"Step_by_Step_Creating_a_Schematic_Using_Precision_Layout\">Step by Step: Creating a Bullet Graph That Displays Target\u00a0vs\u00a0Planned<\/span><\/span><\/span><\/span><\/span><\/h3>\n<p class=\"intro-text\">Before you start, open a new tab in Explorer and click the \u201cCreate a New Page in Studio Mode\u201d thumbnail.\u00a0Choose the <a title=\"Grid Layout\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/grid-layout\/\">grid<\/a>\u00a0layout \u2013 you can adjust the rows and columns if you like but it\u2019s not important for this exercise.<\/p>\n<p class=\"intro-text\">You will need to adjust the configuration to suit your data at your site.<\/p>\n<p class=\"intro-text\"><strong>Step 1. Add\u00a0the source data<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/meterdata.png\" rel=\"lightbox[1829] lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3526\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/meterdata-800x511.png\" alt=\"meterdata\" width=\"800\" height=\"511\" \/><\/a><\/p>\n<p class=\"intro-text\">Before we can display any\u00a0data on the page, \u00a0we need to add the source data.<\/p>\n<ul class=\"intro-text\">\n<li>Below the canvas, click the button labelled \u201c<a title=\"Add Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/\">Add Data<\/a>\u201c.<\/li>\n<li>Choose the data you are going to use. For this tutorial, we are using a <a title=\"Add a Relational Dataset\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/add-data\/add-a-dataset\/\">dataset<\/a> called \u201cWelPlanningData\u201d.<\/li>\n<li>In the configuration options, specify the following:\n<ul class=\"intro-text\">\n<li>Name: WelPlanningData1 (this is automatically added)<\/li>\n<li>Query: WelPlanningData (this is the query in P2 Server that is being used to return the data)<\/li>\n<li>StartDate: (Datetime)\u00a001\/04\/2015 12:00:00 AM<\/li>\n<li>EndDate: (Datetime)\u00a030\/04\/2015 12:00:00 AM<\/li>\n<li>EntitiesList: (Event) selectedEntity<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 2. Add\u00a0the\u00a0Bullet Graph<\/strong><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletdrag.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3563\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletdrag-800x381.png\" alt=\"bulletdrag\" width=\"800\" height=\"381\" \/><\/a><\/p>\n<p class=\"intro-text\">Drag and drop the Bullet Graph component\u00a0onto a grid cell.\u00a0The Bullet Graph\u00a0is in the Chart\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1837\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" alt=\"chartsicon_sm\" width=\"22\" height=\"17\" \/><\/a>\u00a0group.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 3. Configure the\u00a0Bullet Graph<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletconfig.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3564\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletconfig-800x420.png\" alt=\"bulletconfig\" width=\"800\" height=\"420\" \/><\/a><\/p>\n<p class=\"intro-text\">Configure the Bullet Graph as follows:\u00a0<\/p>\n<ul class=\"intro-text\">\n<li>Source Data:\u00a0WelPlanningData1<\/li>\n<li>Measure 1 Column: (Text) OilP10<\/li>\n<li>Measure 2 Column: (Text) OilP50<\/li>\n<li>Measure 3 Column: (Text) OilP90<\/li>\n<li>Actual Column: (Text) OilActual<\/li>\n<li>Target Column: (Text) OilPlanned<\/li>\n<\/ul>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 4. Add\u00a0the Entity Selector<\/strong><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/targetentity.png\" rel=\"lightbox[1795] lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3537\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/targetentity-800x379.png\" alt=\"targetentity\" width=\"800\" height=\"379\" \/><\/a><\/p>\n<p class=\"intro-text\">This step allows the user to select an entity, which will drive the meter indicator and measures.<\/p>\n<ul class=\"intro-text\">\n<li>Drag and drop the <a title=\"Entity Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/entity-selector\/\">Entity Selector<\/a> control onto the canvas.<\/li>\n<li>Configure it as follows:\n<ul class=\"intro-text\">\n<li>Selected Entity: selectedEntity<\/li>\n<li>Selected Entities: (blank)<\/li>\n<li>Hierarchy Name: (Text) Oil and Gas<\/li>\n<li>Template Filter: (Text) Oil Producing Well<\/li>\n<li>Number of Selections: 1<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"intro-text\">\u00a0<\/p>\n<p class=\"intro-text\"><strong>Step 5. All done!<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3565\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png\" alt=\"bulletfinal\" width=\"441\" height=\"542\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal.png 441w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-122x150.png 122w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/bulletfinal-39x48.png 39w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n<p class=\"intro-text\">Congratulations! You now have a Bullet Graph that will show you actual vs planned\u00a0oil\u00a0production for a selected well.<\/p>\n<ul class=\"intro-text\">\n<li>Click the preview\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox[1433] lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a>\u00a0button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li>Select different entities and observe the changes in the graph.<\/li>\n<\/ul>\n<p class=\"intro-text\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1348\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png\" alt=\"save\" width=\"48\" height=\"53\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-43x48.png 43w\" sizes=\"auto, (max-width: 48px) 100vw, 48px\" \/> Don\u2019t forget to <a title=\"Saving Your Page\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-create-your-first-page\/saving-your-page\/\">save your page<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Bullet Graph is similar to a horizontal bar chart but allows users to compare two values in relation to one another.  This article describes how to configure a bullet graph in versions 4.3.2 and earlier of P2 Explorer.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/bullet-graph-4-3-2\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":4633,"parent":2682,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[15,518],"class_list":["post-15380","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-charts-2","tag-graphs","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/15380","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=15380"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/15380\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2682"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/4633"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=15380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=15380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=15380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}